Home » RDBMS Server » Security » access error with grant and CREATE_GROUP_FROM_QUERY
access error with grant and CREATE_GROUP_FROM_QUERY [message #48560] Mon, 29 November 2004 14:08
hudo
Messages: 165
Registered: May 2004
Senior Member
Hello,
I created a form which uses a hierarchical tree for navigation within the form.
The queries in the forms are based on stored procedures.
I created a role with grant execute on these stored procedures.
Then some other user are assigned to this role.

Problems arise by starting the form as a "non-owner-user", the errors
FRM-41072: Cannot create group
FRM-41076: Error filling the group
FRM-47322: Tree-source is norecord group
occur which are assigned to the group created for the navigation with
the hierarchical tree.
In general these errors occur when a group is created from a query, e.g.:

rg_navi := CREATE_GROUP_FROM_QUERY('rg_navi',
'SELECT 1 ,level ,thetext ,NULL ,TO_CHAR(nr) '||
'FROM NAVIGATION '||
'CONNECT BY PRIOR nr = lev '||

'START WITH UPPER(gohere) = ''STARTELEMENT'' ');

How can this problem be solved ?
Previous Topic: hide/encrypt password in database
Next Topic: Host Authentication
Goto Forum:
  


Current Time: Thu Mar 28 21:39:59 CDT 2024