var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: alter session set current_schema
Anyone see a downside to using alter session set current_schema=dataowner;
in a logon trigger?
So support users can use SQL without specifying owner
The other option would be private or public synonyms
If we are talking about a limited/small set of users I'd go for the private synonyms solution.
I try to avoid public synonyms as much as possible because they tend to create a mess of the database, especially when you are running different applications on the same instance.
So if you are talking about a huge number of users (where creating the synonyms for each user ist not feasible) I'd go for the logon trigger.
Thanks, I have similar feelings about synonyms. I'm going to try out the alter session in a logon trigger, I can't see where it would be a problem.
remember, it only set the base schema. All the rights to select, update, or delete from the table must still be given to the user.
Originally Posted by Indy_tomcat
You do not need a parachute to skydive. You only need a parachute to skydive twice.