Home » RDBMS Server » Server Administration » connection problem
connection problem [message #55057] Mon, 30 December 2002 23:53 Go to next message
chintan
Messages: 7
Registered: September 2002
Junior Member
when i type "connect system/manager as sysdba" it gives me insufficent privileges error. so how can i overcome this problem becoz if i add sysdba privileges to system user through oracle navigator it gives me same error so plz help me to remove this erro
thnaks in advance
chintan
Re: connection problem [message #55058 is a reply to message #55057] Tue, 31 December 2002 00:18 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hi,
system will not have sysdba privilege attached...
all u need to do is connect as sys instead of system..
proceed as follows

connect sys as sysdba
change_on_install (default password)

sai
Previous Topic: rbs - urgent
Next Topic: Rollback segments offline/recreation.
Goto Forum:
  


Current Time: Sat Dec 28 06:33:34 CST 2024