OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » dbschema (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbschema (merged) [message #357320]

Tue, 04 November 2008 20:59

Amulyadeep
Messages: 6
Registered: October 2008

Junior Member

Hello all,

is there any way to check if the run sql query is hitting the right schema??

there are 2 schemas, one is owner and the other is the user; user has all the permissiong of select, update, insert commands;

i am using toad and when i log in db_user schema i am not able to see the table view ; when i run the query though i can see all the tables in the db_user schema;

basically both the user schema is a mirror to owner schema..

so i wnat to know when i execute the select * from tab; in user which schema/db it is communicating.

Hope u experts can help me out..

cheers
Amulya

Report message to a moderator

Re: dbschema [message #357326 is a reply to message #357320]

Tue, 04 November 2008 22:50

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Don't give user privileges on owner then you are sure you are accessing user schema objects.
Also, remove synonyms, especially public ones.

Regards
Michel

Report message to a moderator