Re: Different types of privileges

There's no such thing as an "admin" privilege.

There are *system* privileges, and object privileges.

How do you tell the difference? If a privilege includes the name of a specific object, it's an object privilege. Otherwise, it's system.

"Select any table" doesn't mention a *specific* object, just tables in general. It's therefore a system privilege.

"Select from emp" is an object privilege, because it mentions the specific table, EMP.

Alternatively, select * from system_privilege_map. Anything listed there is a system privilege, strangely enough.

Not having much luck reading (or understanding) the documentation, are you?

~QM

"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 Sat Jun 28 2003 - 16:48:39 CDT