Home » SQL & PL/SQL » SQL & PL/SQL » How To Select Other user's Table
How To Select Other user's Table [message #206481] Thu, 30 November 2006 04:44 Go to next message
Messages: 2
Registered: November 2006
Location: India
Junior Member
dear all

How the sys user can fire a select query on the tables created by other users in other schemas.

Re: How To Select Other user's Table [message #206494 is a reply to message #206481] Thu, 30 November 2006 05:18 Go to previous message
Messages: 21130
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
By preceding table name with user name, such as

SELECT * FROM user.table_name;
Previous Topic: regarding to database session
Next Topic: Query optimization
Goto Forum:

Current Time: Wed Jul 26 03:53:00 CDT 2017

Total time taken to generate the page: 0.33063 seconds