| Package Privilege [message #190795] |
Fri, 01 September 2006 05:09  |
linyumin
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  |
rampratap
Messages: 50
Registered: November 2004
Location: New Delhi
|
Member |
|
|
Hi,
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
