Create view from DBA_ROLES for non-privileged users?

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 reports of what users are in which roles). Received on Thu Jun 12 2008 - 09:50:27 CDT