Xref: alice comp.databases.oracle.server:46434
Path: alice!news-feed.fnsi.net!news.idt.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: Steve Adams <steve.adams@ixora.com.au>
Newsgroups: comp.databases.oracle.server
Subject: Re: How to make x$view available to user ?
Date: Tue, 20 Apr 1999 13:14:06 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 26
Message-ID: <7fhuit$i01$1@nnrp1.dejanews.com>
References: <7fhpah$d99$1@nnrp1.dejanews.com>
X-Article-Creation-Date: Tue Apr 20 13:14:06 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 95)
X-Http-Proxy: 1.1 x2.dejanews.com:80 (Squid/1.1.22) for client 203.17.124.165

Hi Ted,

As SYS ...

create view x_$kcbcbh as select * from x$kcbcbh;
grant select on x_$kcbcbh to public;
create public synonym x$kcbcbh for x_$kcbcbh;

Regards,
Steve Adams

----------
In article <7fhpah$d99$1@nnrp1.dejanews.com>,
  tedchyn@yahoo.com wrote:
> Sir, Is it possible to make x$views such as x$kcbcbh, x$kccts available
> to other user than sys. I tried to do grant and got ora 2030 (grant
> must be from a fixed view problem).
>
> Thanks  Ted Chyn(respond to tedchyn#yahoo.com)
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own