Re: allowing ordinary user to select on all system views

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 Thu May 07 1998 - 01:44:28 CDT