- Can someone clarify the difference between logging in as SYS and SYSTEM
via SQL*PLUS?
- If in both cases you log in as SYSDBA (via SQL*PLUS), is there a
difference?
- What does it mean in each case if you **don't** specify "AS SYSDBA" when
logging in via SQL*PLUS. Don't they both belong to SYSDBA role anyway?
- Why does Enterprise Manager Console, in some of my installations (can't
remember, perhaps 8i?), not let me specify "AS SYSDBA" when logging in as
SYSTEM, but only recognizes "AS NORMAL"?
- Why with Oracle 9.2.0.3 am I able to log in as
"SYS/CHANGE_ON_INSTALL_at_mydatabase AS SYSDBA" when the database setup
required me to change the password for SYS and SYSTEM? It also allows me to
log in as SYSTEM/MANAGER as well, although I supplied a new password during
database creation. These are fresh databases newly created under 9.2.0.3,
not migrations.
I welcome all thoughts and discussion on this.
-Randy Nichols
Received on Wed Aug 06 2003 - 10:36:40 CDT
