Share
ReportHello Friends,
I Cannot find table "securityrole" but can find other tables like SecurityUserRole, UserInfo etc ?
I check in AOT and sql server database but luck ?
I am trying to run below query, it fails since it cannot find table SECURITYROLE
select SecurityUserRole.user_ , userinfo.Name , securityRole.aotname
from [MicrosoftDynamicsAX_model].[dbo].[SECURITYROLE] ,
[MicrosoftDynamicsAX].[dbo].[SECURITYUSERROLE] ,
[MicrosoftDynamicsAX].[dbo].[userinfo]
where securityRole.RecId = SecurityUserRole.SecurityRole and
userinfo.id = SecurityUserRole.user_ and
userinfo.enable = 1
order by SecurityUserRole.user_ , securityRole.aotname
;
*This post is locked for comments
All responses (
Answers (
8,072
