Re: allowing ordinary user to select on all system views

From: Neil Chandler <oracle_at_tchp2.tcamuk.stratus.com>
Date: 11 May 1998 08:57:20 GMT
Message-ID: <slrn6ldf8p.bqf.oracle@tchp2.tcamuk.stratus.com>

In article <3551654F.16C08AE8_at_vrijuit.nl>, Jeroen van Sluisdam wrote:

You are unable to grant to the V$ views. You must grant to the underlying V_$ objects.

However, if you logon as SYS and run $ORACLE_HOME/rdbms/admin/utlmontr.sql a 'monitorer' role is created and granted to public thus achieving a similar result with the control and tidiness of a role.

It is invariably tidier to grant to roles and grant the relevant roles to the users who need them

regs

Neil Chandler

>Better would be not granting everything to everybody, bit something like:
>select 'grant select on ' || object_name || ' to public; '
>from dba_objects
>where object_name like 'V%'
>and owner = 'SYS'
>
>Jeroen
>
>chrisoc_at_ans.net wrote:
>
>> What's the easiest way to grant select on all system views to an
>> ordinary user? What I really want to know is more general, I guess
>> -- how to grant User A select on entire schema of User B,
>> even for future objects created in B's schema.
>>
>> Chris O'Connor
>>
>> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
>
>
Received on Mon May 11 1998 - 03:57:20 CDT