Home » RDBMS Server » Server Administration » user sys to query tables created by other user.
user sys to query tables created by other user. [message #54753] Tue, 03 December 2002 04:31 Go to next message
Armando
Messages: 6
Registered: December 2002
Junior Member
being a user sys(dba) how can i query tables created by other user

Report message to a moderator

Re: user sys to query tables created by other user. [message #54754 is a reply to message #54753] Tue, 03 December 2002 04:48 Go to previous messageGo to next message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Try like this
select * from <Schema>.

sai

Report message to a moderator

Re: user sys to query tables created by other user. [message #54768 is a reply to message #54754] Wed, 04 December 2002 02:28 Go to previous message
Armando
Messages: 6
Registered: December 2002
Junior Member
thanks for the answer.

regards,
armando

Report message to a moderator

Previous Topic: Schema and User
Next Topic: Don't know what is my connection identifier?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:53:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.