Skip to content
Home » Oracle Database » User and Role » Privilege » How to Resolve ORA-01700: duplicate username in list

How to Resolve ORA-01700: duplicate username in list

ORA-01700

Tried to grant a privilege to some users, but it failed with ORA-01700.

SQL> grant create session to erpapp1, erpapp2, erpapp3, erpapp1;
grant create session to erpapp1, erpapp2, erpapp3, erpapp1
                                                   *
ERROR at line 1:
ORA-01700: duplicate username in list

ORA-01700 means that there's a duplicated username in the grantee list, you have to identify it then remove or replace with a different one.

In this case, we correct the grantee list like this:

SQL> grant create session to erpapp1, erpapp2, erpapp3, erpapp4;

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 *