SYS Privilege

2004-01-19 Thread Hamid Alavi
Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone :

RE: SYS Privilege

2004-01-19 Thread DENNIS WILLIAMS
Hamid - Are you using sqlplus or sysmgr? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 19, 2004 1:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege

RE: SYS Privilege

2004-01-19 Thread Jay
What is the value of your remote_login_password init parameter? What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file? -Original Message- Hamid Alavi Sent: Monday, January 19, 2004 2:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password

RE: SYS Privilege

2004-01-19 Thread Hamid Alavi
sqlplus -Original Message- Sent: Monday, January 19, 2004 2:00 PM To: Multiple recipients of list ORACLE-L Hamid - Are you using sqlplus or sysmgr? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 19, 2004 1:49 PM To: Multiple

RE: SYS Privilege

2004-01-19 Thread Hamid Alavi
here it is: remote_login_password= EXCLUSIVE sqlnet.authentication=(NTS) -Original Message- Sent: Monday, January 19, 2004 2:01 PM To: Multiple recipients of list ORACLE-L What is the value of your remote_login_password init parameter? What is the value of SQLNET.AUTHENTICATION_SERVICES

RE: SYS Privilege

2004-01-19 Thread Michael Milligan
Do you have that password in your password file? -Original Message- Sent: Monday, January 19, 2004 4:14 PM To: Multiple recipients of list ORACLE-L here it is: remote_login_password= EXCLUSIVE sqlnet.authentication=(NTS) -Original Message- Sent: Monday, January 19, 2004 2:01 PM

RE: SYS Privilege

2004-01-19 Thread Hamid Alavi
the password still is chamge_on_install I could connect as a normal user means it's there but not enough privilege to connect as sysdba. -Original Message- Sent: Monday, January 19, 2004 3:25 PM To: Multiple recipients of list ORACLE-L Do you have that password in your password file?

RE: SYS Privilege

2004-01-19 Thread Jared . Still
:RE: SYS Privilege the password still is chamge_on_install I could connect as a normal user means it's there but not enough privilege to connect as sysdba. -Original Message- Sent: Monday, January 19, 2004 3:25 PM To: Multiple recipients of list ORACLE-L Do you have that password

RE: SYS Privilege

2004-01-19 Thread Michael Milligan
Use the ORAPWD.EXE utility and create a password file: Assume your DB name is test: 1. Find any files named testpwd.ora. 2. Delete these file(s) 3. Find orapwd.exe and, at the command line: c:\oracle\ora92\bin orapwd file=testpwd.ora password=ginger no spaces before or after the=signs. The