Issue
Create table command fails with below mentioned error
ERROR at line 1:ORA-01031: insufficient privileges
Here are the list of privileges granted
SQL> select * from session_privs;PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE
Resolution
Grant the below mentioned privileges to the user then re login to database. Now execute the create table statement, it must run successfully. In case you face any issue, please write the comment below
SQL> grant resource to hr;
Grant succeeded.
No comments:
Post a Comment