Re: [O8] Security Manager As SYSDBA ?

Normal users should not logon as SYS (as this is the dictionary owner). To perform standard DBA work either log on as SYSTEM or grant the DBA role to your choosen user.

The SYSDBA and SYSOPER roles allow the DBA to logon in the SYS schema and allow such features as shutdown and recovery. To use SYSDBA you need to have REMOTE_LOGIN_PASSWORD = EXCLUSIVE set in the init.ora, then grant this role to the user. The fixed view v$pwfile_users contains the users granted these roles.

Please remember from 8.1 onwards the internal user will be removed.

Regards
David Russell

Lee, Junho wrote in message <6hu2pv$krc$1_at_jagalchi.cc.pusan.ac.kr>...
>Hello everyone!
>
>I have questions as a beginner of Oracle DB.
>
>O. I installed Oracle8 server now.
>
>O. I am willing to enter the security manager
> with
> user id : sys
> password: change_on_install
> as
> SYSDBA
>
>O. I got insufficient privileges Message
>
>O. As normal, no problem.
>
>Can I enter the manager or db as SYSDBA?
>Please help me here!
>
>[thank you]_______________________________
>
>p.s. This version is a trial version
>
>
Received on Sun Apr 26 1998 - 10:23:12 CDT