Grant SYS.x$KCCCP to DBA...................

[marjina98]

Hi,

How should we grant SYS.x$KCCCP to DBA?
I am using following command to grant SYS.x$KCCCP to DBA but getting the following error:

*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views

I am using version 8.1.7.0



Thanks

Marjina

[davey23uk]

try x_$..

[abhaysk]

Looks like you are trying to grant access on that fixed table other than SELECT?

Abhay.

[reydp]

Originally posted by marjina98
Hi,

How should we grant SYS.x$KCCCP to DBA?
I am using following command to grant SYS.x$KCCCP to DBA but getting the following error:

*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views

I am using version 8.1.7.0



Thanks

Marjina

fixed tables are solely owned by sys/internal and it should not be touch other than select, that is why views are created like DBA_* and V$* for.

[akkerend]

You cannot grant a select privilige on a x$ table. Create a view on the x$ table and grant select privilege on the view.

SQL> grant select on SYS.x$KCCCP to dba;
grant select on SYS.x$KCCCP to dba
*
ERROR at line 1:
ORA-02030: can only select from fixed tables/views


SQL> create view sys.my$kcccp
2 as
3 select * from x$kcccp;

View created.

SQL> grant select on sys.my$kcccp to dba;

Grant succeeded.

SQL> conn system/manager@mydb
Connected.
SQL> select * from sys.my$kcccp;

[marjina98]

Thanks,

Is creating a view on fixed tables is the only solution for my query?
Should the view which we created for the fixed table SYS.x$KCCCP refresh implicitly?
By default is there an alternative view of this fixed table SYS.x$KCCCP available, if so what is that view.

Thanks

Marjina

[marjina98]

Hi,

I am looking forward to hearing from someone to give me the answer of my last post.

Regards

MArjina

[akhadar]

I don't think that u have an explicit view.Follow as explained by the other member.

[shans]

x$kcccp means kernel cache checkpoint progress. None of the v$/gv$ views exposes these table columns. You can not grant x$ table directly. This is a restriction with x$ table.

Thanks and Regards,
Satheesh Babu.S