Home » RDBMS Server » Security » View package body role (Oracle 8.1.7.4 AIX)
View package body role [message #345969] Fri, 05 September 2008 07:32 Go to next message
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
Re: View package body role [message #345971 is a reply to message #345969] Fri, 05 September 2008 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: View package body role [message #346676 is a reply to message #345969] Tue, 09 September 2008 05:56 Go to previous message
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.

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


Current Time: Thu Mar 28 10:34:23 CDT 2024