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 ????
"SYS".USER_ROLE_PRIVS may help or what about DOMAIN.ROLEPRIVILEGES where tablename IS NULL > OR to Show all users and their assigned user groups: > SELECT * FROM ???? no "SYS"-View may help, because they are for Oracle-mode, Oracle does not know user-goups in SAP DB -sense --> no such view available. DOMAIN.USERS is ok. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
