I have logged into a dev02 schema with a user and password and another schema dev08 with a different user/password in the Oracle database. Now from dev02, I run the command: truncate table dev08.table_name I get ORA-01031: insufficient privileges error. What are the options I have here?
I came across an article, from which I can create a procedure in dev08 to truncate the tables which I want which can be run from dev02.
Is there any alternative to this like granting permission to dev02 to truncate a list of tables? or creating a procedure is a good approach?
- Is there a way to grant truncate privileges on a single or a set of tables?