Is it possible to create a view based off DBA_ROLES so that a non-DBA
user can keep track of which users belong to roles associated with his
department? In this case, all roles associated with the specific
department are named with a common prefix, e.g. ABC_<rest of role
name>.
I'm thinking of something like the following:
CREATE VIEW ABC_USER_ROLES as
SELECT USERNAME, GRANTED_ROLE
FROM DBA_ROLES
WHERE GRANTED_ROLE LIKE '%ABC_%';
Is there any technical or security issue in creating a view like this
for the user.
It would be a time-saver for all concerned to have the view (vs.
generating static re****ts of what users are in which roles).
