Re: How to do...

For a start, log in as that user and explore the user_objects table( for those that the user created) and the user_objects table( for those that the user has access to) ..
Or log in as a DBA and check the dba_objects tables and select where owner = [that user] or check your CRUD info...

( if you do not know the user's log in, and you are not the DBA, why do you want to know?)

mqben_at_aol.com (MqBen) wrote:

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

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Wed Dec 19 2001 - 11:41:13 CST