Re: How Does user have unlimited tablespace privilege?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Wed, 14 Jun 2000 15:43:57 -0400
Message-Id: <10528.109291@fatcity.com>

Matthew is right. As I recall=20
As I recall, the reason for this behavior came about as a result of the need for Oracle7 to be backwards compatible with Oracle 6.

Jonathan

---

jonathan_at_gennick.com =20
http://gennick.com
Brighten the Corner Where You Are

On Tue, 13 Jun 2000 13:13:25 -0800, Matthew Adams wrote:

>close but not quite right. The unlimited tablespace
>priv is the only system priv that cannot be granted to a=20
>role. BUT it is implicitly granted when=20
>the resource or dba role is granted.
>
>So grant resource then revoke unlimited tablespace.
Received on Wed Jun 14 2000 - 14:43:57 CDT