| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Need an explanation for
My understanding is that the password file is used to store the passwords
for the password (not OS) authenticated users with SYSDBA and SYSOPER
privileges. Thus Oracle can authenticate them before the data dictionary is
available.
HTH, Dr. Nikolay Kumanov
MIS Manager, Zeitungsgruppe Bulgarien GmbH 47, Tsarigradsko chaussee, Sofia 1504, Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 mailto:nkumanov_at_zgb.bg
"Show me a completely smooth operation and I'll show you someone who's covering mistakes. Real boats rock." - Frank Herbert, "Chapterhouse: Dune"
-----Original Message-----
From: S Jayakumar [mailto:jaykumar_at_mahindrabt.com]
Sent: Tuesday, October 17, 2000 4:06 PM
To: Multiple recipients of list ORACLE-L
Subject: Need an explanation for
Hi DBAs,
I have a funny query in my mind & I a convincing explanation from You. I granted DBA role to scott user for test purpose. But scott is able to connect as SUSDBA thru svrmgrl & able to start , shut the database.
My doubt is , during startup when the datanase is not up how DBA role is effective to scott user as Oracle has not mounted the data dictionery to refer the roles granted to scott user.
Any explanations please ?
I have give the sequence of actions below as it was.
Thanks
S Jayakumar
Connected.
SVRMGR> create role abc ;
Statement processed.
SVRMGR> grant dba to abc ;
Statement processed.
SVRMGR> grant abc to scott;
Statement processed.
SVRMGR> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SVRMGR> SVRMGR> SVRMGR> connect scott/tiger as sysdba;
Total System Global Area 7650832 bytes Fixed Size 48656 bytes Variable Size 6701056 bytes Database Buffers 819200 bytes Redo Buffers 81920 bytesDatabase mounted.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: S Jayakumar
INET: jaykumar_at_mahindrabt.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Tue Oct 17 2000 - 09:42:21 CDT
 |
 |