Hi All,
It is my lab to do basic Oracle Admin.
I created a db - "orcl" administrated by SYS and also created a user "Usr2";
The default schema of Usr2 is SYS.
I tried SET SCHEMA statement
"SET SCHEMA USR2";
but return
line 1: SQLPLUS Command Skipped: set schema USR2;
May i know if it is possible to change the default schema of USR2?
Is it i need to set every i connect to db?
ALTER SESSION SET CURRENT_SCHEMA = USR2;
I also search a trigger solution.
http://stackoverflow.com/questions/283589/oracle-setting-per-user-default-scheme-not-altering-a-session
(May it be a privilegd issues, it is no working for mine)
Thank you very much.