ORA-20126 in Review Definition User Selection query with custom table in the AVCSUSER schema in RSA Governance & Lifecycle
3 years ago
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-2022-10-13-11-14-48-970.png

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.
  
 

Related Articles

Trending Articles

Don't see what you're looking for?