Dynamics Community Forum Thread Details

Security Report

Hi all,

Greetings!

We have received a new requirement to develop a Security Report and the fields are mention below:-

User ID

Alias

User Name

Account Type

Account Status

Entity

Roles

Date Role Assigned

Role Created Date

Role Modified Date

Role Enabled

Table

Table Access level

Form

Control

Effective Access

Server method

Policy Enabled

Policy Name

Policy Created Date

Policy Modified Date

Query Name

Query Created Date

Query Modified Date

Duties

Duty Created Date

Duty Modified Date

Duty Enabled

Privileges

Privilege Created Date

Privilege Modified Date

Priviledge Enabled

Table

Access level

Form

Control

Effective Access

Server method

Entry Point

Access Level

I have found till the Role Table Name from where i can fetch the data. Requesting all of you if you can provide the data source and relation information throughout the AOT(System Documentation Tables).

UserInfo(UserInfo).networkAlia

UserInfo(UserInfo).accountType

UserInfo(UserInfo).enable

OMUserRoleOrganization

(SecurityRole).dEL_CreatedTime
Need to check

(SecurityRole).dEL_modifieddatetime
Need to check

Roles->Properties Enabled(Need to check)

Roles->Permissions->Tables

Roles->Permissions->Tables->Properties->EffectiveAccess

Roles->Permissions->Form

Roles->Permissions->Forms->Properties->Control

Roles->Permissions->Forms->Properties->EffectiveAccess

Roles->Permissions->Server method->

Policies->Policy->Properties->Enables

Policies->Policy Name

Policies->Policy->Properties->CreatedDateTime

Policies->Policy->Properties->ModifiedDateTime

Policies->Policy->Properties->Query

AOT->Query->Properties->CreatedDateTime

AOT->Query->Properties->ChangedDate

(SecurityRoleTaskGrant.SecurityRole==securityuserrole.securityrole )SecurityRoleTaskGrant.SecurityTask == SecurityTask.RecId && SecurityTask.Type == Duty (SecurityTask.Name)

AOT->Security-> Duties-> Properties->Created date

AOT->Security-> Duties-> Properties->Changed date

AOT->Security->Roles-> Duties-> Enabled

AOT->Security->Roles-> Privilege-> Priviledge name …........................AOT->Security->Roles-> Duty-> Priviledge name

AOT->Security-> Privilege-> Properties->Created date

AOT->Security-> Privilege-> Properties->Changed date

AOT->Security-> Privilege-> Properties->Enabled

Privilege->Permissions->Tables

Privilege->Permissions->Tables->Properties->EffectiveAccess

Privilege->Permissions->Form

Privilege->Permissions->Forms->Properties->Control

Privilege->Permissions->Forms->Properties->EffectiveAccess