Re: restrict the object privilege of a owner

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 11 Nov 2000 21:53:24 +1100
Message-ID: <3a0d255c@news.iprimus.com.au>

Nope. Owners of objects have full permissions on those objects, and they can't be taken away from them.

If you log on as, say system, and try revoking object privileges from the table owner, you'll get a "ORA-01927: cannot REVOKE privileges you did not grant" error message.

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


"sp" <sdpant_at_yahoo.com> wrote in message
news:2m1P5.1619$A26.68810_at_sjc-read.news.verio.net...


> Is it possible to restrict the privilege of a user (who happens to be a

> owner)?

>

> In other words, there is a object 'tableA' under a schema 'userJoe'.  At

 the


> same time is it possible to restrict the permissions of userJoe to tableA?

> I just want to give select permission.

>

> Thanx in advance.

>

> SP

>

>

>

>

Received on Sat Nov 11 2000 - 04:53:24 CST