AnsweredAssumed Answered

ODF Custom Virtual Table Lost Privilege's

Question asked by JP_Thompson on May 25, 2018
Latest reply on Jun 1, 2018 by JP_Thompson

Hello Community Members,

 

We recently had an issue with an odf custom virtual table, "view", where it lost privilege's.  We have been using this table for the last 2 years with no such incidents like this occurring.  Our DBA Staff noted that the virtual tables where created on the day we could no longer see them or use them,

Our DBA's note,

"I checked NIKU.ODF_RESOURCE_RATE_V, which I believe has been having grant issues.
That view was created on 5/16 and has no grants assigned to it, along with 2 other views  created on the same day:"

 

We had two incidents occur during the same time frame as our virtual table issue, our "Rate Matrix Extraction Job" failed after 10+ hours of running, we also ran out of temp space on our oracle instance, the long running job used up most of the temp space, so it failed.

Has anyone encountered similar issues like this?  Also, I would like to know if the "Rate Matrix Extraction Job" touches any of the tables that comprise our virtual tables, potentially causing the issue we had?

 

The tables that make the virtual table are listed below:

NIKU.CMN_LOOKUPS_V

NIKU.ODF_CA_RESOURCE_RATE

NIKU.CMN_SEC_USERS

NIKU.CMN_LANGUAGES

 

Any insight or thoughts would be grateful and much appreciated.

 

Thank You & Regards

Jonathan

Outcomes