Privilege required to check archive log list
593619Oct 25 2011 — edited Oct 25 2011what privilege required to run archive log list command.
I have my user created on database and granted DBA privilege. But when I connect as sqlplus username/password and run archive log list.
It is throwing me below error
SQL> archive log list;
ORA-01031: insufficient privileges
SQL>
but when I connect as sqlplus susername/passwd as sysdaba. It allow me to run the command archive log list.
But my concern is when i connect using sqlplus susername/passwd as sysdaba it show me user sys when I run show user command.
I do not want to login as SYS instead my user and run this command.
Any recommendation please.