Home » RDBMS Server » Server Administration » dbschema (merged)
dbschema (merged) [message #357320] Tue, 04 November 2008 20:59 Go to next message
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
Re: dbschema [message #357326 is a reply to message #357320] Tue, 04 November 2008 22:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
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
Re: sql -db schema [message #357327 is a reply to message #357320] Tue, 04 November 2008 22:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost your questions.

Regards
Michel
Re: sql -db schema [message #357543 is a reply to message #357327] Wed, 05 November 2008 17:31 Go to previous message
Amulyadeep
Messages: 6
Registered: October 2008
Junior Member
Hi Michael,

Thank you for you help..
it works
Previous Topic: problem with execute privilege on sys.truncate_table
Next Topic: Log Destination
Goto Forum:
  


Current Time: Tue Nov 05 13:45:18 CST 2024