Re: User priviliges

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 10 Mar 2005 07:47:08 -0500
Message-ID: <dPCdnZQoyepT3K3fRVn-sg@comcast.com>

"Nicolas Bronke" <Nicolas_bronke_at_web.de> wrote in message news:39atcnF5vjupeU1_at_individual.net...
>I am searching for the possibility to find out, what kind ov user rights
>the current user has.
> Detecting the roles are easy (user_role_privs)
> Detecting System privs also (user_sys_privs)
>
> But what I did not found are indirect rights. E. g. User has the role x
> granted. and the role x has the sys priv e.g. create user.
>
> Is there any way to get this information? At least it would be fine to do
> this whithout having advanced privs.
>
> Kind regards
> Nicolas

session_privs

++ mcs Received on Thu Mar 10 2005 - 06:47:08 CST