Re: Selecting from the X$ views/tables

nickkeeman_at_my-deja.com wrote:
: I would like to use the X$ tables in some of my queries, but can not
: select from them. My DBA says they're only accessable for user SYS. Is
: this true and if so is there no workaround for this?

        There is idea

create or replace view X_$BH as select * from X$BH;

        create some view
create public synonym X$BH for sys.X_$BH;

        create public synonym for it
grant select on X_$BH to banka;

        and grant select to your user

        and now you can select from x$ views as sys usually do.

Next scripts will help you to du this things. Spool it into file and you will gain SQLs for your job.

        I hope it helps. Starous

• views select 'create or replace view ' || 'X_$' || replace ( name, 'X$', '' ) || ' as select * from ' || name || ';' from v$fixed_table where name like 'X$%' order by name;
• public synonyms select 'create public synonym ' || name || ' for sys.X_$' || replace ( name, 'X$', '' ) || ';' from v$fixed_table where name like 'X$%' order by name;
• grants select 'grant select on ' || 'X_$' || replace ( name, 'X$', '' ) || ' to banka;' from v$fixed_table where name like 'X$%' order by name;