Home » SQL & PL/SQL » SQL & PL/SQL » non schema user
non schema user [message #444039] Thu, 18 February 2010 07:35 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
does a non schema user have to append schema prefix for every database object ?
Re: non schema user [message #444040 is a reply to message #444039] Thu, 18 February 2010 07:40 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
No. He has to prefix the prefix.
Re: non schema user [message #444041 is a reply to message #444039] Thu, 18 February 2010 07:50 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Not if there is a public synonym.
Re: non schema user [message #444045 is a reply to message #444039] Thu, 18 February 2010 08:11 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or he can have a private synonym,
or he can use ALTER SESSION SET CURRENT_SCHEMA to change the user that is used for resolving references.
Re: non schema user [message #444048 is a reply to message #444039] Thu, 18 February 2010 08:41 Go to previous messageGo to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
I trying to do without synonym, if there is anyother way without sybnonym ?
how does this ALTER SESSION SET CURRENT_SCHEMA work?
we get connection using java so everytime I get connection I have first call this ?

Re: non schema user [message #444050 is a reply to message #444048] Thu, 18 February 2010 08:49 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>how does this ALTER SESSION SET CURRENT_SCHEMA work?

Unwilling or incapable to Read The Fine Manual?

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2012.htm#i2231814
Re: non schema user [message #444098 is a reply to message #444039] Thu, 18 February 2010 12:36 Go to previous messageGo to next message
cristi_Buc
Messages: 12
Registered: February 2010
Location: Bucharest
Junior Member

schema A has a table t.
Schema/ user B wants to read the table t from A schema.
--------------------------------------------------------
If all the rights are done:

From schema B:

select * from A.t;

OR

create synonym t for A.t;
select * from t;

this is a case of synonym usage.
Re: non schema user [message #444100 is a reply to message #444098] Thu, 18 February 2010 12:46 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This latter case under the condition that A schema does not contain a T table or view.

Regards
Michel

[Updated on: Thu, 18 February 2010 12:46]

Report message to a moderator

Previous Topic: Using For Update in Cursor
Next Topic: Working days
Goto Forum:
  


Current Time: Sat Dec 03 19:53:51 CST 2016

Total time taken to generate the page: 0.10640 seconds