| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: V$ rights
Eike J. Heinze wrote:
>
> Hi;
>
> If you are on a Unix system:
> Run $ORACLE_HOME/rdbms/admin.UTLMONTR.sql for that user. Path aso for
> Unix.
> On WinNt up to Oracle 8.0.5 see
> %ORACLE_HOME%\RDBMSxx\ADMIN\UTLMONTR.sql
Just for information, if you want to give access to just a few V$ views
instead of the full set and if you try (as SYS) to grant something such
as
SVRMGR> connect internal
Connected
SVRMGR> grant select on V$SESSION to scott;
then you get insulted;
However
SVRMGR> grant select on V_$SESSION to scott;
works (and has the same effect).
That's life with Oracle.
--
Regards,
Stéphane Faroult
Oriole Corporation
Performance Tools & Free Scripts
 |
 |