| Execution procedure privileges [message #9957] |
Wed, 17 December 2003 05:35  |
Mark
Messages: 284
Registered: July 1998
|
Senior Member |
|
|
How can I grant execution of packaged procedure to another user ?
The script, assuming as I logged in as an owner of this package:
GRANT EXECUTE package_name.proc_name TO user1; -- does not work
Also, in what system table can I find info about execute privileges ?
Thanks
|
|
|
|
| Re: Execution procedure privileges [message #9959 is a reply to message #9957] |
Wed, 17 December 2003 06:09  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
You grant execute privilege on the package to other users or roles.
Grant execute on package_name to user1;
select * from dba_tab_privs where table_name='PACKAGE_NAME';
select * from dba_tab_privs where PRIVILEGE='EXECUTE' and owner='SCOTT';
For object privileges granted to roles, use role_tab_privs
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
