Editing object results in "ORA-20025: No role access" error
search cancel

Editing object results in "ORA-20025: No role access" error

book

Article ID: 88169

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

When editing an object, the following error may occur:
 
ORA-20025: No role access to " role OPS_NO_EDIT in get_role_seq_aw when add_obj_roles


Investigation:

User Group(s) are assigned to a User, and define what a User can view or edit. This error can be seen by User "John", in the following configuration:

User John has User Group A assigned to the user
The object throwing the "No role access" error is owned by User Group A and User Group B
User Group B is not assigned to User Group A

 

 

Environment

OS Version: N/A

Cause

Behavior is as designed and is caused by the way that the groups are assigned.

Resolution

User Group A requires indirect access to User Group B. 

This can be done by editing User Group A and assigning User Group B to User Group A.


Additional Information

Workaround :
N/A