Environment
Oracle Database
Oracle 10
NetIQ AppManager for UNIX
Situation
Resolution
DROP ROLE SELECT_VDOLLAR_ROLE;
CREATE ROLE SELECT_VDOLLAR_ROLE;
BEGIN
FOR x IN ( SELECT object_name
FROM dba_objects
WHERE object_type = 'VIEW'
AND object_name LIKE 'V\_$%' ESCAPE '\' )
LOOP
EXECUTE IMMEDIATE 'grant select on ' || x.object_name || ' to SELECT_VDOLLAR_ROLE';
END LOOP;
END;
/
now grant SELECT_VDOLLAR_ROLE to whomever you wish to be able to look at v$ views.
Cause
Additional Information
Noted at https://forums.oracle.com/forums/thread.jspa?threadID=1081883
Please keep in mind support for this KB is best effortas this falls under the scope of database administration.