Re: Who has what rights on tables they do not own.

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Mon, 13 Sep 2004 14:42:23 -0500
Message-ID: <cutbk0tni8edadm9tiikl2mcaopcqbm8pg@4ax.com>

watuni2000_at_yahoo.co.nz (Tyler Smith Watu) wrote:

>I like sql to be able to get all tables that users have rights to in
>the database but which they do not own.
>Preferably NOT by entering the user name each time as a result of &
>
>TIA
>TY

Select owner,tablename from all_tables;

This will list all the tables the user running the query has access to.

( use user_tables - to see those the user 'owns') Received on Mon Sep 13 2004 - 14:42:23 CDT

This message: [ Message body ]
Next message: Joel Garry: "Re: Make a database accessible over the internet"
Previous message: Mark C. Stock: "Re: Make a database accessible over the internet"
In reply to: Tyler Smith Watu: "Who has what rights on tables they do not own."
Next in thread: Pete Finnigan: "Re: Who has what rights on tables they do not own."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US