Home » RDBMS Server » Server Administration » acceess schema objects withour schema name
acceess schema objects withour schema name [message #62941] Wed, 25 August 2004 04:28 Go to next message
shyam
Messages: 25
Registered: January 2001
Junior Member
i granted a schema to some object privileges to another schema for objects.Is there any way that schema can refrenence my objects except schemaname.table_name .I dont want to create  synonymns.How to do this

with regards

shyam

 

 

 

Report message to a moderator

Re: acceess schema objects withour schema name [message #62942 is a reply to message #62941] Wed, 25 August 2004 04:41 Go to previous message
nabila
Messages: 13
Registered: April 2003
Junior Member
Alter session set CURRENT_SCHEMA=YOURSCHEMA

but it is undocumented .

Report message to a moderator

Previous Topic: Performance tuning of Oracle latches
Next Topic: Reg the compatiblity of oracle versions
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 08:23:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.