Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Read-only DBA-privileges ?
> You could try granting select on the various views to the user. Since
> the views are owned by SYS, you might need to log in as SYS to do the
> grant.
To do this, you'll have to log on as sys and grant select privileges on the V_$ view. For instance, to let USERX select from V$PROCESS, you'll need to issue:
GRANT SELECT ON V_$PROCESS TO USERX; But you must be connected as SYS!
This works for version 7!
HTH,
Brian
--