This functionality is already built in
Try ALL_TAB_COLUMNS when logged in as BAR. I'm somewhat suprised that grant
select on user_tab_columns to XXXX; doesn't through an error.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Markus Boehmer" <markus.boehmer_at_schaefer-shop.de> wrote in message
news:3E1C476C.7020108_at_schaefer-shop.de...
> Hi guys and gals,
>
> I have a little problem.
>
> I have two users, FOO and BAR.
> User FOO has a table named zugriffe.
>
> User BAR has only the right to connect to the databse and
> the right to select from user FOO's user_tab_columns.
>
>
> Here is what I have done:
> connect FOO/***
> create table zugriffe (
> leckmich date
> );
> grant select on user_tab_columns to BAR;
>
> connect BAR/***
> select * from FOO.user_tab_columns;
> ERROR at line 1:
> ORA-00942: table or view does not exist
>
>
> Now I thought I could try to fool oracle and make a view,
> table zugriffe still exists:
> connect FOO/***
> CREATE VIEW TABELLENNAMEN AS
> (SELECT DISTINCT TABLE_NAME FROM USER_TAB_COLUMNS);
> grant select on tabellennamen to BAR;
>
> connect BAR/***
> select * from FOO.tabellennamen;
>
> no rows selected
>
> connect FOO/***
> select * from FOO.tabellennamen;
> TABLE_NAME
> ------------------------------
> TABELLENNAMEN
> ZUGRIFFE
>
>
> Why doesn't get the user BAR the data?
>
> I hope someone has a ssuggestion.
> I have to find out how to make a user with nearly no rights to get
> information about the table names and structures of some other users.
>
> Greetings
> Markus
>
Received on Wed Jan 08 2003 - 10:10:44 CST
