Skip to content
Home » Oracle » How to Resolve ORA-01917: user or role does not exist

How to Resolve ORA-01917: user or role does not exist

ORA-01917

Tried to grant a privilege to an user, but it failed with ORA-01917.

SQL> grant create session to erapp;
grant create session to erapp
                        *
ERROR at line 1:
ORA-01917: user or role 'ERAPP' does not exist

ORA-01917 means that the grantee you specified in the statement or during import is neither an user nor a role, you have to use a valid user or role to make it. For data pump, you have to create the user or role before importing.

In this case, we correct the grantee into a valid user like this:

SQL> grant create session to erpapp;

Grant succeeded.

There're more examples to grant privileges correctly, you may have a look.

Leave a Reply

Your email address will not be published. Required fields are marked *