Re: Simple question
From: Adrian Hands <AHands_at_sprynet.com>
Date: Wed, 02 Dec 1998 22:22:35 -0500
Message-ID: <366603FB.EBDF2485_at_sprynet.com>
Date: Wed, 02 Dec 1998 22:22:35 -0500
Message-ID: <366603FB.EBDF2485_at_sprynet.com>
Daniel Bertha wrote:
>
> How do I view the list of users that have access to a specific table??
>
> Thanx in advance.
select atp.grantee, atp.privlege
from all_tab_privs atp
where atp.table_schema = 'ADRIAN'
and atp.table_name = 'T_FOO'
;
Received on Thu Dec 03 1998 - 04:22:35 CET