Hi Everybody,
Recently a test database of OTM 5.5 version was export and imported in Oracle 10g. However after import, after executing the after import steps as mention in Administration guide, on execution of vpd.set_user('DBA.ADMIN'); I am getting excecption as below -
ORA-01031: insufficient privileges
ORA-06512: at "GLOGOWNER.VPD", line 205
ORA-06512: at "GLOGOWNER.VPD", line 214
ORA-06512: at line 1
The creation of user and roles were created using the scripts provided by OTM script8 folder.. Even if I exec vpd.set_user('DBA.ADMIN') as user sys also, I am getting the same exception.
Appreciate if you can point out what is being missed out to fix this issue if you have encountered a similar scenario.
Thanks,
Suresh
Recently a test database of OTM 5.5 version was export and imported in Oracle 10g. However after import, after executing the after import steps as mention in Administration guide, on execution of vpd.set_user('DBA.ADMIN'); I am getting excecption as below -
ORA-01031: insufficient privileges
ORA-06512: at "GLOGOWNER.VPD", line 205
ORA-06512: at "GLOGOWNER.VPD", line 214
ORA-06512: at line 1
The creation of user and roles were created using the scripts provided by OTM script8 folder.. Even if I exec vpd.set_user('DBA.ADMIN') as user sys also, I am getting the same exception.
Appreciate if you can point out what is being missed out to fix this issue if you have encountered a similar scenario.
Thanks,
Suresh
Comment