Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

are there permissions required to delete table_names in user_tables

1022160Jul 3 2013 — edited Jul 3 2013

i have  written  a stored procedure in it there is a line

"Delete from User_tables where TABLE_NAME like v_TableName;" this query deletes contents in TABLE_NAME column of USER_TABLES in DATABASE

but when i executed it it is showing ERROR  ": ORA-01031: insufficient privileges" i have seen session privileges but it is having CREATE PROCEDURE,CREATE ANY PROCEDURE,DELETE ANY TABLE

priveleges what could be the problem
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2013
Added on Jul 3 2013
#general-database-discussions
1 comment
266 views