Joe Garrett wrote: > Hello, > > When signed on as SYSDBA, I see how to Show list of all users: > SELECT * FROM "SYS"."DBA_USERS" > > and how to Show list of all roles: > select * from "SYS"."DBA_ROLE_PRIVS" > > and how to Show users and user groups and roles and their > privileges for a > table: > SELECT * FROM "SYS"."DBA_TAB_PRIVS" WHERE table_name = 'TEST_TABLE_1' > > BUT I CAN'T see how to Show all users and their assigned roles: > SELECT * FROM ????
what about DOMAIN.ROLEPRIVILEGES where tablename IS NULL > OR to Show all users and their assigned user groups: > SELECT * FROM ???? DOMAIN.USERS Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
