OraFAQ Forum: SQL & PL/SQL » How To Select Other user's Table

Home » SQL & PL/SQL » SQL & PL/SQL » How To Select Other user's Table

Thu, 30 November 2006 04:44

ramjidas
Messages: 2
Registered: November 2006
Location: India

Junior Member

hi
dear all

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

ramji

Thu, 30 November 2006 05:18

Littlefoot
Messages: 21823
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 Dec 11 21:47:29 CST 2024