|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
access problem with grant and CREATE_GROUP_FROM_QUERY
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 ? |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > access problem with grant and CREATE_GROUP_FROM_QUERY |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|