Re: SYS vs. SYSTEM

On Thu, 7 Aug 2003 12:48:47 +0300, Tanel Poder <tanel@@peldik.com> wrote:

> Hi!
>
> I remember sysdba/sysoper mentioned as roles in older Oracle course
> materials I've instructed, probably because these privileges actually
> give
> you a bunch of other privileges (in addition to startup, shutdown,
> recover
> etc.. rights), just like roles usually do...
>
> Tanel.

OK, but in that case, where is the 'create index' system privilege? Well, it doesn't exist. That's because 'create table' implies that you can also create indexes on it. Likewise, there's no 'drop index' system privilege. Therefore, 'create table' implies at least two other privileges. So do we call that a role as well?

I think not. We just accept that some system *privileges* imply the grant of other things. SYSDBA is no different in that respect.

Let's call a spade a spade and not a gardening hoe.

~QM Received on Thu Aug 07 2003 - 05:16:46 CDT