Hi all,
I am trying (just for testing) to add to another user ( MYUSER) the SYSDBA or SYSOPER privileges in order to let him open the DB.
What I have :
My parameter remote_login_passwordfile is set to exclusive.
I have only one DB ( and one instance) installed locally on a NT machine.
I have successfully given the privileges to this user,( see below a query about V$PWFILE_USERS) and see this user in my pw file.
I still can not open the DB ( see below).
Anyone could help?
Connecté Ã* :
Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
INTERNAL TRUE TRUE
SYS TRUE TRUE
MYUSER TRUE TRUE
SQL> connect myuser/myuser;
Connecté.
SQL> startup
ORA-01031: privilèges insuffisants
SQL>