| Granting create package [message #62316] |
Wed, 14 July 2004 03:39  |
Sam
Messages: 255
Registered: April 2000
|
Senior Member |
|
|
hi i would like to grant a user, create package privilege.
where do i check if he is already having one if not how can i grant him, pls let me know the syntax aswell.
thanx in advance.
|
|
|
|
| Re: Granting create package [message #62327 is a reply to message #62316] |
Wed, 14 July 2004 13:04  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
A user must have the "CREATE PROCEDURE" or "CREATE ANY PROCEDURE" privilege (or a role with one of these privileges granted to it) before that user can create procedures, functions and packages. Look at this example:
SQL> GRANT create procedure TO scott;
Grant succeeded.
SQL> SELECT grantee, privilege FROM dba_sys_privs
2 WHERE grantee = 'SCOTT';
GRANTEE PRIVILEGE
------------------------------ ----------------------------------------
SCOTT CREATE PROCEDURE
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
