Re: SYS vs. SYSTEM

From: Tanel Poder <tanel_at_@peldik.com>
Date: Thu, 7 Aug 2003 14:53:37 +0300
Message-ID: <3f323dc2$1_1@news.estpak.ee>

> 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. Received on Thu Aug 07 2003 - 06:53:37 CDT