Re: Privilege on user_constraints, user_cons_columns and user_tab_columns
Date: Tue, 29 Apr 2003 14:07:43 +0400
Message-ID: <b8lj00$50o7_at_news-dxb.emirates.net.ae>
Hello,
user_constraints, user_cons_columns and user_tab_columns : contains information on the tables that the user creates in his own schema. If a grants has been given on these tables to other users, than these user can find this info in all_constraints, all_cons_columns and all_tab_columns. In the query they should specify the name of the owner.
Good Luck
"kennypoon" <member6892_at_dbforums.com> wrote in message
news:2818742.1051600119_at_dbforums.com...
>
> I am new in Oracle. I have several SQL statement which use
> user_constraints, user_cons_columns and user_tab_columns tables. Are all
> user can read their constraints, columns? How can the admin to set that
> the user which can't access above tables.
>
> --
> Posted via http://dbforums.com
Received on Tue Apr 29 2003 - 12:07:43 CEST