Re: change users' default schema

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: Roger.Xu@xxxxxxxxxxx
  • Date: Thu, 2 Nov 2006 13:12:08 -0800

On 11/2/06, Roger Xu <Roger.Xu@xxxxxxxxxxx> wrote:

Can I change a user's default schema, so he dose not need to type
SCOTT.EMP just EMP?
(This user does nothing but queries SCOTT's tables.)
I know "Synonyms" can be created to bypass the prefix requirement.



alter session set current_schema = scott;

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: