Making packages visible to another user - Urgent [message #137659] |
Fri, 16 September 2005 00:37 |
guyj
Messages: 31 Registered: September 2005
|
Member |
|
|
Hi All,
My scenario is like this. I have 2 users. UserA and UserB. Now I want to give permissions to UserB, to view and modify table data, packages and sequences which are owned by UserA. I followed the following steps but still UserB can not view the package bodies.
Grant create session to UserB
Grant select,insert,update on < UserA.table name > to UserB
Grant execute on < UserA.packages> to UserB
Grant select on < UserA.sequences > to UserB
Please help me to solve this issue.
|
|
|
|
|
|
|
|
|