Re: rights on data dictionary views

On Wed, 08 Jan 2003 16:44:44 +0100, Markus Boehmer <markus.boehmer_at_schaefer-shop.de> wrote:

>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.

So use ALL_TABLES and ALL_TAB_COLUMNS where owner = 'FOO'

and try studying the structure of the datadictionary instead of trying to hack yourself a way out.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jan 08 2003 - 10:31:36 CST