Re: What rights do I need to give a user to view system views?

Eric Bennett wrote:
>
> For example I want to get a list of columns in a table from the
> user_tab_columns view.
>
> If I connect as the owner I can get the list, but If I don't I can't.
> Is there a rights grant that will let a regular user see this view?
>

You need to grant at least the SELECT privilege to the other user to see this table:

(as OWNER) GRANT SELECT on tab TO OTHER_USER

Then, OTHER_USER sees this table in his all_* views. The user_* views contain the objects one _owns_. The all_* views contain the object one has access to.

U.

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Haydnstr. 1         | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!