Dear Friends,
I am getting below error while running a procedure.
Error starting at line 32 in command:
BEGIN ADDTABLEIFNOTEXISTS(); END;
Error report:
ORA-01031: insufficient privileges
ORA-06512: at "BOP.ADDTABLEIFNOTEXISTS", line 6
ORA-06512: at line 1
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if
attempting to install a database without the necessary operating
system privileges.
When Trusted Oracle is configure in DBMS MAC, this error may occur
if the user was granted the necessary privilege at a higher label
than the current login.
*Action: Ask the database administrator to perform the operation or grant
the required privileges.
For Trusted Oracle users getting this error although granted the
the appropriate privilege at a higher label, ask the database
administrator to regrant the privilege at the appropriate label.
the User contain DBA ROLE, And i tried to provide EXECUTE ANY PROCEDURE to that user, But still i am getting the same error.
I tried with "GRANT EXECUTE ANY PROCEDURE TO BOP WITH ADMIN OPTION;"
"GRANT EXECUTE ANY PROCEDURE TO BOP;" but no use
Do i need to give any other permissions?