why do i get ORA-01031: insufficient privileges ?
SQL> grant create view to rojib;
grant create view to rojib * ERROR at line 1: ORA-01031: insufficient privileges
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
In order to grant the
CREATE VIEW privilege, your user needs the
CREATE VIEW privilege
WITH ADMIN OPTION, or the
GRANT ANY PRIVILEGE system privilege. Otherwise you have insufficient privileges.
To grant a system privilege, one of the following conditions must be met:
You must have been granted the GRANT ANY PRIVILEGE system privilege. In this case, if you grant the system privilege to a role, then a user to whom the role has been granted does not have the privilege unless the role is enabled in user's session.
You must have been granted the system privilege with the ADMIN OPTION. In this case, if you grant the system privilege to a role, then a user to whom the role has been granted has the privilege regardless whether the role is enabled in the user's session.