Re: USER_SYS_PRIVS and DBA_SYS_PRIVS

Maybe the ALL_, USER_, and DBA_ apply to objects only. As you cannot look at other's privileges because there is no 'GRANT SELECT ON <priv>...'. There's no need to look into other's privileges than to 'have' (been granted) these privileges

And I think the naming convention doesn't apply to privileges, unlike objects.

cheers,
geoffrey

suisum_at_ecn.ab.ca wrote:
>
> Hi Geoffrey:
>
> Thanks a lot for your reply.
>
> Actaully, my question is in name convention of the view. Consider the
> following:
>
> ALL_TABLES - Table objects the user can access.
> USER_TABLES - Table objects owned by the user.
> DBA_TABLES - All table objects in the database.
>
> But I can't apply this name convention for _SYS_PRIVS view.
>
> Thanks,
>
Received on Mon Jan 11 1999 - 19:43:49 CST