Home » RDBMS Server » Server Administration » Package Privilege
Package Privilege [message #190795] Fri, 01 September 2006 05:09 Go to next message
Messages: 13
Registered: August 2006
Location: Taiwan Taipei
Junior Member

Hi all~

My database has an user(v3) schema,

Now I want to grant privileges to an user(test) that executing and debugging packages owned by v3,and further user(test) can modify some specified packages'spec owned by v3 but not all.

I've granted EXECUTE on all packages owned by v3 to test
and granted debug any procedure to test~
but test still can't modify the specified packages owned by v3

Does anyone have a good idea to achieve that???

[Updated on: Fri, 01 September 2006 05:11]

Report message to a moderator

Re: Package Privilege [message #190919 is a reply to message #190795] Sat, 02 September 2006 09:18 Go to previous message
Messages: 50
Registered: November 2004
Location: New Delhi


Login as system/manager@orcl as sysdba
grant alter any procedure to test

after this command test can modify the procedure of v3

RP Singh
Previous Topic: Dump area used
Next Topic: 10g server installation
Goto Forum:

Current Time: Wed Oct 26 22:41:13 CDT 2016

Total time taken to generate the page: 0.13369 seconds