Re: How can a User see other tables ( when granted select priveleges ) ??
Date: Mon, 23 Jul 2001 18:10:33 +0400
Message-ID: <9jhatp$f77$1_at_news247.cnt.ru>
Hello!
Don <don_at_xxx.com> ñîîáùèë â íîâîñòÿõ
ñëåäóþùåå:h1aoltotbvdmpg6ogkmqjpn14ri33no822_at_4ax.com...
> User001 can always see his own tables
> by select * from cat;
>
> Output:
> User001.emp
> User001.dept
> User001.project
>
>
> Let's say that User044
> gives select privilege on his table to User001.
>
>
> How does User001
> make a select statement to see a list of tables that he is "allowed"
> to see ? ( Meaning his own tables and User044's tables )
>
select owner||'.'||table_name from all_tables where owner in ('USER001','USER044');
Best regards!
Yaroslav.
>
> desired output list:
>
> User001.emp
> User001.dept
> User001.project
> User044.inventory
> User044.salary
> User044.job
>
>
>
Received on Mon Jul 23 2001 - 16:10:33 CEST