Re: Logging in "AS SYSDBA" vs. without it ("NORMAL")

"ohaya" <ohaya_at_cox.net> a écrit dans le message de news:41E881D0.12873BA7_at_cox.net...
| Hi,
|
| Suppose that I have created a user ("foo") in the database instance
| "foodb" using sqlplus. I have also granted the user "foo" several
| roles, including "CONNECT", "DBA", and "RESOURCE". The user password
| was assigned in the "CREATE USER", as "foopwd".
|
| When I connect as user "foo", I can enter either "foopwd" or "foopwd as
| sysdba" as the password.
|
| I was wondering if someone could tell me, in general, exactly what the
| difference is between using the different password forms?
|
| For example, if I login using the password "foopwd as sysdba", do I get
| more of the roles that were granted to the user vs. if I login using the
| password "foopwd"?
|
| How exactly does this work?
|
| Thanks,
| Jim

2 sections to read:

User Authentication:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c23acces.htm#CNCPT323

Database Administrator Authentication:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#1064

Regards
Michel Cadot Received on Sat Jan 15 2005 - 00:03:11 CST