Article Content
Article Number | 000028840 |
Applies To | Affected Versions: All Versions |
Resolution | The following sql can be used to determine what entitlements are in a role: Login as the avuser and select the information from these tables where the entitlement ids in T_AV_ROLEDEFINITIONS table match the entitlement ids in T_ENTITLEMENTS. A sample session is shown below: $ sqlplus avuser/<password> SQL> select r.run_id, t.id, t.resource_name from t_entitlements t, t_av_roledefinitions r where t.id = r.ent_id; SQL> exit $ |