ORA-20126 in Review Definition User Selection query with custom table in the AVCSUSER schema in RSA Governance & Lifecycle
RSA Governance & Lifecycle 7.5.2
When trying to add a where clause in the review definition to read a custom table in the AVCSUSER schema, you will get the below error.
ERROR:-20126:The creation of reviews failed. ORA-20126: The creation of reviews failed. Stored Procedure:Parse_User_Review execution aborted. ORA-20126: The creation of reviews failed. Stored Procedure:Parse_Users_In_User_Review execution aborted. ORA-00942: table or view does not exist.
Explicit permissions should be granted on tables created on AVCSUSER schema to AVUSER for access.
Read-only permissions are granted on AVUSER tables to AVCUSUSER, But for any new custom tables created in one of the schemas, permission has to be granted explicitly.