Re: How to view keys & privileges on table?

select * from user_tab_privs_made

select table_name, index_name, column_name from user_ind_columns
order by table_name, index_name, column_position.

Hth,

Sybrand Bakker, Oracle DBA

"Daniel" <dlrubinANTI-SPAM_at_yahoo.com> wrote in message news:3A58A2AE.EB9F68D9_at_yahoo.com...
> How I can view the privileges that a table has granted to other users?
> Also, how di I list the keys on a table (they're not listed using
> DESCRIBE).
> Thanks.
> Daniel
> --
> To reply to me directly, please remove "ANTISPAM" from the reply-to
> email address.
>
>
Received on Sun Jan 07 2001 - 11:26:12 CST