Re: SYS vs. SYSTEM

On Wed, 6 Aug 2003 20:39:23 GMT, Brian Peasland <dba_at_remove_spam.peasland.com> wrote:

>> 1. Can someone clarify the difference between logging in as SYS and
>> SYSTEM
>> via SQL*PLUS?
>
> SYS and SYSTEM are two different accounts in the database. Each have
> their own tables, etc.
>
>> 2. If in both cases you log in as SYSDBA (via SQL*PLUS), is there a
>> difference?
>
> If you connect as SYSDBA, then there isn't a difference. See the
> following:
>
> SQL> connect / as sysdba
> Connected.
> SQL> show user
> USER is "SYS"
> SQL> connect system
> Enter password: Connected.
> SQL> show user
> USER is "SYSTEM"
> SQL> connect system as sysdba
> Enter password: Connected.
> SQL> show user
> USER is "SYS"
>
>> 3. 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?
>
> SYSDBA is not a traditional role like CONNECT, RESOURCE, etc. You can't
> see it when you query DBA_ROLES:
>
> SQL> select role from dba_roles where role='SYSDBA';
>
> no rows selected

That's because it isn't a role at all, but a system privilege. Number 83 or 94 (memory fails me) in the select * from system_privilege_map.

~QM Received on Wed Aug 06 2003 - 16:08:51 CDT