ORA-20126 in Review Definition User Selection query with custom table in the AVCSUSER schema in RSA Governance & Lifecycle

[#1]

Article Number

000067979

Applies To

• RSA Governance & Lifecycle 7.5.2

Issue

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.

Image description

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.

Resolution

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.