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

From: ohaya <ohaya_at_cox.net>
Date: Fri, 14 Jan 2005 21:37:04 -0500
Message-ID: <41E881D0.12873BA7@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 Received on Fri Jan 14 2005 - 20:37:04 CST