| archive log list - ORA-01031: insufficient privileges [message #241596] |
Wed, 30 May 2007 02:31  |
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
