Re: Different types of privileges

From: Andrew Deighton <andrew_at_phaldor-it.n0spam.com>
Date: Thu, 26 Jun 2003 11:13:29 +0100
Message-ID: <pFzKa.44152$xd5.2192927@stones.force9.net>

SYSTEM privileges are specific to the database as a whole, e.g. CREATE

SESSION or SELECT ANY TABLE.

OBJECT privileges are specific to a particular object, e.g. SELECT ON

MY_TABLE OBJECT privileges can be granted with GRANT OPTION, which allows the grantee

to grant the same privilege to other users.

SYSTEM privileges can be granted with ADMIN OPTION, which allows them to be

granted to other users.

If you revoke an OBJECT privilege from a user, it is also revoked from all

the users that user has granted it to.

If you revoke a SYSTEM privilege from a user, it has no impact on grants

that user has made.

OBJECT privileges are seen in DBA_TAB_PRIVS, SYSTEM privileges are in

DBA_SYS_PRIVS. I hope this helps.

Andrew

www.Phaldor-IT.com

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:igflfv4if67o6kcge4b6ibe732424hpq3l_at_4ax.com...
> How do you distinguish between an admin privilege and an object
> privilege?
>
> Thanks
Received on Thu Jun 26 2003 - 05:13:29 CDT