| 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 ?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
