OraFAQ Forum: Security » Making packages visible to another user

Home » RDBMS Server » Security » Making packages visible to another user - Urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: Making packages visible to another user - Urgent [message #137718 is a reply to message #137659]

Fri, 16 September 2005 04:39

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

Report message to a moderator

Re: Making packages visible to another user - Urgent [message #137721 is a reply to message #137718]

Fri, 16 September 2005 05:08

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

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

Report message to a moderator

Re: Making packages visible to another user - Urgent [message #137731 is a reply to message #137723]

Fri, 16 September 2005 06:16

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.

Report message to a moderator