User uses Virtual Private Database (VPD) security and SQL Optimizer 7.2 does not allow user to set the proper environment before running and, therefore, program errors out. Is there a plan for integrating VPD/environment configuration functions into this tool?
WORKAROUND:
Depending on how VPD has been setup, a logon trigger may be used to configure the session environment.
STATUS:
Issue fixed in latest version of SQL Optimizer which can be downloaded here.
Once installed go to Options | General | Options | check box 'Execute Login Script'
A sql script can be selected to run on connection to setup any environment specific settings e.g.
begin
dbms_session.set_identifier(accountid);
end;
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center