| grant privilege for package execute [message #49862] |
Thu, 14 February 2002 09:37  |
denise chase
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
Within a database, we are having difficulties granting and EXECUTE privilege to a package object. We are using the SYS user to grant the privilege to another user set up within the database. The error message we get is:
ORA-01031 Insufficient privileges
You do not have enough privileges to perform this operation. You must have the appropriate system and object privileges to create, edit, or drop database objects or objects outside your schema.
What privileges does SYS need to do this operation to another user?
|
|
|
|
| Re: grant privilege for package execute [message #49863 is a reply to message #49862] |
Thu, 14 February 2002 10:56  |
Rajesh Aialavajjala
Messages: 15
Registered: January 2002
|
Junior Member |
|
|
Greetings Denise!!
It appears that the package that you are seeking to grant the EXECUTE privilege on is not owned by the user SYS. As you will know, database privileges fall into two categories viz:
System Privileges (CREATE,ALTER,DROP etc...)
Object Privileges (SELECT,INSERT,UPDATE etc...)
with the chief distinction being that SYSTEM privileges can be granted by a user with the DBA role attached (typically SYS or SYSTEM), and OBJECT privileges being granted ONLY by the OWNER of the object in question. For example, the following GRANT statement issued by SYS would raise an error stating 'Insufficient Privileges'
SQL>conn sys/change_on_install
SQL>grant select on scott.emp to demo;
The error is owing to the fact that the object EMP is owned by SCOTT and only SCOTT is permitted to grant any object privileges in respect of the table EMP.
Attempt to issue the EXECUTE privilege while connected as the owner of the package.
I hope this information helps.
Best Wishes,
Rajesh Aialavajjala
|
|
|
|
| Re: grant privilege for package execute [message #49867 is a reply to message #49863] |
Thu, 14 February 2002 13:54 |
denise chase
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
Thank you Rajesh. We ended up compiling the package under the SYS user and then granted the EXECUTE privilege to the other user. When we tried to grant the privilege when signed on as the other user we got the error message ORA 01749 you may not grant privileges to yourself. It seemed we were in a loop but after reading your reply, it seemed to make sense to make SYS the owner.
Denise
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
