Insufficient privileges error when creating stored procedure |
 |
EXPERT RESPONSE FROM: Brian Peasland1
|
|
|
|
| > |
QUESTION POSED ON: 18 July 2007
I need to create a stored procedure in my schema, using Toad. However, it gives me the error "Insufficient privileges." Again, if I connect as System and prefix the schema name to the table (schema.tablename), it says the table does not exist. Please help.
|
|
|
To continue reading for free, register below or login
To read more you must become a member of SearchOracle.com
In order to create a stored procedure in your schema, you need to have the CREATE PROCEDURE system privilege. This can be verified by querying DBA_SYS_PRIVS for your user. Furthermore, if the stored procedure references objects, the user that owns the stored procedure must have the appropriate object privileges as well. For instance, if the stored procedure inserts a row of data into the SCOTT.EMP table, the user that owns the stored procedure must have been granted INSERT on this table. And the grant cannot be through a role. You will need to grant this object privilege directly to the user.
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
