ORA-01919:
This example, tested on Oracle 10g , demonstrates the ORA-01919 error
message, which some people find misleading. First create a user called ANAND, a role
called newrole and another user called ANOTHER_USER
SQL> conn / as sysdba
Connected.
SQL> grant create session to anand
2 identified by anand
3 /
Grant succeeded.
SQL> create role newrole
2 /
Role created.
SQL> create user another_user
2 identified by another_user
3 /
User created.
SQL>
Connect as ANAND then try to grant role NEWROLE to ANOTHER_USER. This
fails but the error message is not helpful. Role NEWROLE does exist but it has not been granted to
ANAND yet:
SQL> conn anand/anand
Connected.
SQL> grant NEWROLE to another_user
2 /
grant newrole to another_user
*
ERROR at line 1:
ORA-01919: role 'newrole' does not exist
SQL>
Grant the role NEWROLE to ANAND:
SQL> conn / as sysdba
Connected.
SQL> grant newrole to anand
2 /
Grant succeeded.
SQL>
Then login as ANAND and try to grant NEWROLE to ANOTHER_USER again. This
time the error message gives a better explanation:
SQL> conn anand/anand
Connected.
SQL> grant newrole to another_user
2 /
grant blah to another_user
*
ERROR at line 1:
ORA-01932: ADMIN option not granted for role 'NEWROLE’
SQL>
Now grant the role to ANAND with the ADMIN option:
SQL> conn / as sysdba
Connected.
SQL> grant newrole to anand
with admin option
2 /
Grant succeeded.
SQL>
Login as ANAND again. This time the GRANT statement works:
SQL> conn anand/anand
Connected.
SQL> grant newrole to another_user
2 /
Grant succeeded.
SQL>
