Re: Roles and SQL

From: Gabri van Lee <gabri_at_deskweb_nospam.nl>
Date: Mon, 1 Feb 1999 18:50:54 +0100
Message-ID: <794pis$nst$1@newsreader.global-one.nl>

DBA_ROLES will tell you which roles exist, SESSION_ROLES will tell you which roles the current user has, USER_ROLE_PRIVS tell you the same for any user.

Grtnx!
Gabri

Julian Cowking wrote in message <794nv6$l8q$1_at_starburst.uk.insnet.net>...
>I am a newbie to Oracle so, this is probably school boy stuff.
>I need to build a list of database roles and a list of database roles to
>which a specified user is assigned.
>Are they stored in system tables as they are in SQL Server?
>Can you help?
>
>Thanks in advance
>JTC
>
>
Received on Mon Feb 01 1999 - 11:50:54 CST