alter session set current_schema = user2;
Open in new window
alter session set current_schema = user1;
Still need the grants...
I wouldn't miss it if Oracle eventually dropped that role completely.
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.