Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Power BI oracle Database do not display data

Hi Guys, We are unable to load data from oracle database.   Before selecting any data to display; we would use below command EXEC VPD.SET_USER('xyz.ADMIN'); Followed by  select command Select *...
  • Anonymous's avatar
    Anonymous
    10 years ago

    Trigger sample

    create or replace TRIGGER loginname.VPD_Logon
      AFTER LOGON
      ON loginname.SCHEMA
    BEGIN
      Vpd.set_user('DBA.ADMIN');
    END;

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Trigger sample

create or replace TRIGGER loginname.VPD_Logon
  AFTER LOGON
  ON loginname.SCHEMA
BEGIN
  Vpd.set_user('DBA.ADMIN');
END;