OraFAQ Forum: SQL & PL/SQL » alter session set schema set schema

Home » SQL & PL/SQL » SQL & PL/SQL » alter session set schema set schema_name

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

alter session set schema set schema_name [message #350582]

Thu, 25 September 2008 08:42

ora1980
Messages: 251
Registered: May 2008

Senior Member

alter session set schema_name = scott;

grant select on scott.emp to rich;

do we need a qualifier if we use alter session set schema_name?

Report message to a moderator

Re: alter session set schema set schema_name [message #350589 is a reply to message #350582]

Thu, 25 September 2008 08:57

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What happens when you try it?

By the way, the first statement is wrong:

SQL> alter session set schema_name = scott;
alter session set schema_name = scott
                  *
ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION

Regards
Michel

Report message to a moderator

Re: alter session set schema set schema_name [message #351017 is a reply to message #350589]

Mon, 29 September 2008 00:23

manojkb
Messages: 16
Registered: March 2006
Location: Dubai

Junior Member

The statement should be like this:

 alter session set current_schema = scott;

and you don't require a qualifier to use the other schema's objects.

Report message to a moderator

Previous Topic:	Need a Sql Statement for following scenario
Next Topic:	whats wrong with this?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 29 17:45:28 CDT 2025