OraFAQ Forum: Security » View package body role

Home » RDBMS Server » Security » View package body role (Oracle 8.1.7.4 AIX)

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

View package body role [message #345969]

Fri, 05 September 2008 07:32

thorin666
Messages: 144
Registered: March 2007

Senior Member

Hi to everyone
i must to give a role to a user to allow him to see my package bodies but i don't know how... can anyone know witch role can i assign him to see my packages or any package in the database?
thank you in advance

Report message to a moderator

Re: View package body role [message #345971 is a reply to message #345969]

Fri, 05 September 2008 07:37

Michel Cadot
Messages: 68748
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no privilege for this but EXECUTE ANY PROCEDURE/CREATE ANY PROCEDURE or SELECT on DBA_SOURCE but I will not recommend to grant these ones.

You can create a procedure in your schem that returns the source of your packaghe and grant the privilege to execute it to your user.

Regards
Michel

Report message to a moderator

Re: View package body role [message #346676 is a reply to message #345969]

Tue, 09 September 2008 05:56

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Does he definitely need to see the source in the Db?
Will the source code in your version/change control system not do?

You could always use Exp/Imp to copy the schems, minus the data, into a new schems for him.

Report message to a moderator

Previous Topic:	expanding audit trail information
Next Topic:	GRANT SELECT ON TABLE(s) FOR ALL USERS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 06:33:12 CDT 2025