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: SYS vs. SYSTEM

Re: SYS vs. SYSTEM

From: quarkman <quarkman_at_myrealbox.com>
Date: Thu, 07 Aug 2003 22:17:01 +1000
Message-ID: <oprtja2nb8zkogxn@haydn>


On Thu, 7 Aug 2003 14:53:37 +0300, Tanel Poder <tanel@@peldik.com> wrote:

>> 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?
>
> Good point. I agree with you it's a special privilege, but I just have
> seen
> it been called a role by Oracle in past.
>
> Tanel.
>

I agree it has. They also have a phrase in the documentation about 'an instance of a database'. It's equally meaningless and wrong.

~QM Received on Thu Aug 07 2003 - 07:17:01 CDT

Original text of this message

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