Q
Problem solve Get help with specific problems with your technologies, process and projects.

Insufficient privileges error when creating stored procedure

I need to create a stored procedure in my schema using Toad but it gives me the error "Insufficient privileges."

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.
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.
This was last published in July 2007

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

God Represent Oracle like Ghee in the milk
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close