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