Re: How to do... OOPS

OK, so I repeated myself..
I meant :
instead of 'the user_objects table( for those that the user has access to)' I should have typed : the all_objects table( for those that the user has access to) Sorry...

TurkBear <jgreco1_at_mn.rr.com> wrote:

>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! ==-----

-----= 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 - 13:36:09 CST