Home » RDBMS Server » Security » Making packages visible to another user - Urgent
Making packages visible to another user - Urgent [message #137659] Fri, 16 September 2005 00:37 Go to next message
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.
Re: Making packages visible to another user - Urgent [message #137718 is a reply to message #137659] Fri, 16 September 2005 04:39 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Forgive me for being obtuse...
How is user b trying to view the procedures?

Jim
Re: Making packages visible to another user - Urgent [message #137721 is a reply to message #137718] Fri, 16 September 2005 05:08 Go to previous messageGo to next message
guyj
Messages: 31
Registered: September 2005
Member
Hi Jim

sorry i forgot to mention that. i gave execute permission to functions and procedures for UserB aswell.

[Updated on: Fri, 16 September 2005 05:12]

Report message to a moderator

Re: Making packages visible to another user - Urgent [message #137723 is a reply to message #137721] Fri, 16 September 2005 05:38 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Yes, but you have not said how you can tell if userB can "see" the procedures. Have you queried all_source?

Jim
Re: Making packages visible to another user - Urgent [message #137731 is a reply to message #137723] Fri, 16 September 2005 06:16 Go to previous messageGo to next message
guyj
Messages: 31
Registered: September 2005
Member

we use Quest sql navigator to query the databases. So basically using that we can see the procedures functions and etc.. so when UserB logs in he can see the packages procedures and functions under UserA.
Re: Making packages visible to another user - Urgent [message #137734 is a reply to message #137731] Fri, 16 September 2005 06:35 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
I know nothing about quest.
Get userb to query the all_source table. if everything is ok then he can see the procs, and it is a navigator issue.

Jim
Re: Making packages visible to another user - Urgent [message #137815 is a reply to message #137734] Sat, 17 September 2005 01:46 Go to previous message
guyj
Messages: 31
Registered: September 2005
Member
UserB can query the all_source table. He can see procs and functions. Thanks Jim.
Previous Topic: Missing Roles
Next Topic: exp/ imp security
Goto Forum:
  


Current Time: Fri Sep 24 07:42:38 CDT 2021