Re: How to make x$view available to user ?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 20 Apr 1999 13:14:06 GMT
Message-ID: <7fhuit$i01$1@nnrp1.dejanews.com>

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_at_nnrp1.dejanews.com>,   tedchyn_at_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 Received on Tue Apr 20 1999 - 08:14:06 CDT