Re: change users' default schema

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: