000028840 - KB-1016 - Where can I find what entitlements are in a role?

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000028840
Applies ToAffected Versions: All Versions
ResolutionThe 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
$

Attachments

    Outcomes