Create view from DBA_ROLES for non-privileged users?
Date: Thu, 12 Jun 2008 07:50:27 -0700 (PDT)
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
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 reports of what users are in which roles). Received on Thu Jun 12 2008 - 09:50:27 CDT