Re: Privileges with grant authority

From: Lev Smirnov <leo_at_dionis.sura.com.ru>
Date: Tue, 28 Nov 2000 20:12:49 GMT
Message-ID: <9013jp$bal$1@nnrp1.deja.com>

In article <900spk$ddd$1_at_news3.infoave.net>, "Chris Boyle" <cboyle_at_no.spam.hargray.com> wrote:
> Okay folks I have seen this described 2 ways in various manuals so I
decided
> to ask people that had experience. If USER A grants USER B a
privilege
> with grant authority and USER B grants the privilege to USER C what
happens
> to USER C if USER A revokes that privilege from USER B? Some of the
books
> say that it will also be revoked from USER C and others state that
USER C
> will retain the privilege. Which is correct? Has this changed with
> different versions of the DBMS (which would explain the inconsistency
across
> books)?
>
> 8i on True 64/NT but I don't have the privileges to test this out
here or I
> wouldn't bother you.
>

There is a cascading effect when revoking an object priviledge. If USER A revokes object priviledge from USER B then it also be revoked from USER C. If USER A revokes system priviledge from USER B then USER C will retain the privilege.

Lev Smirnov
Brainbench MVP for Oracle Admin
http://www.brainbench.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 28 2000 - 14:12:49 CST