Home » SQL & PL/SQL » SQL & PL/SQL » How to see other account's table structure in JDBC
How to see other account's table structure in JDBC [message #37898] Tue, 05 March 2002 09:22 Go to next message
Chen Wen
Messages: 26
Registered: February 2002
Junior Member
Hi,
If I want to see the table structure that the table
is from another user how grant me to the table, how to
do that?
For example, there is one user named "john", he has
one table named "manager". And he granted me to see
the table. How can I get the table's structure?
select *
from user_tab_columns
where table_name='john.manager'
Thanks.

Report message to a moderator

Re: How to see other account's table structure in JDBC [message #37900 is a reply to message #37898] Tue, 05 March 2002 10:19 Go to previous message
Raj
Messages: 411
Registered: November 1998
Senior Member
If you have select privilege, then you can view by
select * from john.manager;

Report message to a moderator

Previous Topic: Error message during count
Next Topic: sql question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 06:58:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.