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
(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: