Grails: Read Oracle Database User Roles -
i'm working on groovy/grails project display roles user assigned in oracle database. possible query information oracle server via groovy/grails? if is, pointers on how appreciated.
there lot of oracle metadata views available. first of there prefix dba_, all_, user_ describes how data see (depending on permissions). list dba_ prefix, replace more restrictive prefix.
you interested in views:
dba_roles dba_role_privs role_tab_privs dba_tab_privs dba_users session_privs session_roles table_privileges
Comments
Post a Comment