Home » SQL & PL/SQL » SQL & PL/SQL » archive log list - ORA-01031: insufficient privileges
archive log list - ORA-01031: insufficient privileges [message #241596] Wed, 30 May 2007 02:31 Go to next message
smora
Messages: 59
Registered: May 2006
Member
Hi

Im using 10.2.0.1.0 EE on Windows Server 2003.

Im trying to enable user hvds to see if the db is running in archivelog mode, and am getting an insufficient privileges error. I tried the following grants, but the user still does not have sufficient privileges. Are there some other grants I have to make?

Thanks
SM

[Logged in as user hvds]
SQL>archive log list
ORA-01031: insufficient privileges

[Logged in as sysdba]
SQL> grant all privileges to hvds with admin option;
Grant succeeded.
SQL> commit;
Commit complete.
SQL> grant select any dictionary to hvds;
Grant succeeded.
SQL> commit;
Commit complete.
SQL> grant sysdba to hvds;
Grant succeeded.
SQL> commit;
Commit complete.

Re: archive log list - ORA-01031: insufficient privileges [message #241604 is a reply to message #241596] Wed, 30 May 2007 02:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is the statement you executed on which you have "insufficient privilege"?
This is maybe the most important information to help you.

If the statement is "archive log list" you must be connected as sysdba (not just has been granted sysdba but connected as sysdba).

Regards
Michel

[edit: add last sentence]

[Updated on: Wed, 30 May 2007 02:52]

Report message to a moderator

Re: archive log list - ORA-01031: insufficient privileges [message #241654 is a reply to message #241596] Wed, 30 May 2007 05:37 Go to previous message
smora
Messages: 59
Registered: May 2006
Member
Thanks Michel, i connected as sysdba and could execute the command.

SM
Previous Topic: ref cursor
Next Topic: Create a trigger on a nested table
Goto Forum:
  


Current Time: Thu Dec 05 12:23:00 CST 2024