Re: Getting available roles and members

Bryan,

> When I am connected as sser TEST2, how can I:
> 1) See all the available roles in the database?

As far as I know, you can't.
Only a DBA can do that,
So, a little workaround, as SYS:

	CREATE VIEW all_roles_in_the_database AS
	SELECT role
	FROM sys.dba_roles;

	GRANT SELECT ON all_roles_in_the_database TO PUBLIC;

And then as TEST2:

        SELECT * FROM sys.all_roles_in_the_database;

> 2) See which roles I (as user TEST2) belong to?

As TEST2:

        SELECT granted_role

        FROM user_role_privs;

HTH, Erwin Received on Fri Sep 21 2001 - 17:33:08 CDT