Re: Some features of Oracle

From: Kim Wykoff <c-wykoff_at_mail.dec.com>
Date: 1997/09/25
Message-ID: <342AC6DF.EBA0E8B7@mail.dec.com>#1/1

Vsevolod Afanasjev wrote:

> Some funny features of Oracle:
>
> 1. RESOURCE and DBA roles carry implicitly the system privilege
>
> UNLIMITED TABLESPACE. This fact is never mentioned in Concepts or
>
> Adm. Guide. It is mentioned only once in SQL Reference. This privilege
>
> does not appear in the list of privileges granted to these roles.
>

Actually, this is mentioned in the dba handbook (7.3) in chapter 9, pp 305 and 307. 307 says dba has all system-level privileges, and 305 says that unlimited tablespace is a system-level privilege.

kim Received on Thu Sep 25 1997 - 00:00:00 CDT