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 ???? OR to Show all users and their assigned user groups: SELECT * FROM ???? _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
