Skip to content
Home » Oracle » How to Resolve ORA-01711: duplicate privilege listed

How to Resolve ORA-01711: duplicate privilege listed

ORA-01711

Tried to grant some privileges to an user, but it failed with ORA-01711.

SQL> grant create session, create session to erpapp;
grant create session, create session to erpapp
                      *
ERROR at line 1:
ORA-01711: duplicate privilege listed

ORA-01711 means that there's a duplicated object in the privilege list, you have to identify it then remove or replace with a valid one.

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

SQL> grant create session, alter 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 *