Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Logging in "AS SYSDBA" vs. without it ("NORMAL")

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

From: Dave <x_at_x.com>
Date: Sat, 15 Jan 2005 12:46:23 GMT
Message-ID: <zg8Gd.10900$GG1.4929@text.news.blueyonder.co.uk>

"ohaya" <ohaya_at_cox.net> wrote in message news:41E8E069.B7BAE0B3_at_cox.net...
>
>
> Michel Cadot wrote:
>>
>> "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
>
>
> Michel,
>
> Thanks for the pointers.
>
> I'm still unclear about:
>
> 1) I did a "select * from v$pwfile_users;". According to one of those
> pages, this is suppose to show users with the SYSDBA privilege, and only
> the "SYS" user was displayed. I thought that only users with the SYSDBA
> privilege could login with "AS SYSDBA", but I can login as my test user
> "foo" with "AS SYSDBA". According toe the "select * from
> v$pwfile_users;", shouldn't only "SYS" be able to login with "AS
> SYSDBA"?
>
> 2) I read through those pages, but am still not 100% clear about what is
> different when I login with "AS SYSDBA" and without "AS SYSDBA". Is the
> only difference that when I login with "AS SYSDBA" that I then have
> access to the "SYS" tables?
>
> Thanks,
> Jim

what os user are you logged in with, if it is a privelegd user you will get in whatever username/password you supply Received on Sat Jan 15 2005 - 06:46:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US