Learn the reason and how to get to the bottom of the ORA-01700 error message in Oracle.
Description
When you encounter an ORA-01700 error, the following error message will appear:
ORA-01700: duplicate username in list
Cause
You tried to execute a GRANT or REVOKE declaration and listed the same username more than once.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Remove the reproduction username from the supply or revoke statement and re-execute the command.
For example, if you tried to execute the following GRANT:
GRANT SELECT ON suppliers TO smithj, andersonb, smithj;
You would receive the following error message:
You may want to correct this error via casting off the 2d occasion of smithj, as follows:
GRANT SELECT ON suppliers TO smithj, andersonb;
Leave a Review