Re: SYS vs. SYSTEM

From: Randy Nichols <randynichols_at_yahoo.com>
Date: Wed, 06 Aug 2003 23:08:33 GMT
Message-ID: <RTfYa.512$Ps.42961@newsread2.prod.itd.earthlink.net>

Thanks everyone for the really great explanations which I will continue to ponder.

-Randy

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:3F317244.4E51994D_at_remove_spam.peasland.com...
> > 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.
>
> I know. And that's what I was trying to point out, that it's not a role
> like other database roles. But I didn't want to confuse the poor chap.
> He was having difficulties with the differences between SYS and SYSTEM.
> And I wouldn't say to that individual that SYSDBA is a system privilege
> less he try to find it in DBA_SYS_PRIVS, where it isn't.
>
> Cheers,
> Brian
>
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
>
Received on Wed Aug 06 2003 - 18:08:33 CDT