Re: How to do...

mqben_at_aol.com (MqBen) wrote in message news:<20011219014648.14751.00000598_at_mb-bj.aol.com>...
> 1.How to do to know all the schema that a user can see in a database after his
> login?
>
> 2. How to do to know all the tables that he can see?
>
> 3. How to do to know indexes build on a table?
>
> 4. How to retrieve the script of creation of a table?
>
> And all things with sql command....
>
> If you have any idea....thanks for your attention.

This type of information is available in the Oracle rdbms dictionary tables/views:

For information of Tables/Indexes/Constrains see http://www.jlcomp.demon.co.uk/faq/object_info.html

For security related views see
http://www.jlcomp.demon.co.uk/faq/privileges.html

• Mark D Powell --