web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

AX security issue

(0) ShareShare
ReportReport
Posted on by 800

Hi ,

I am getting issue with some user(specific rights) while accessing any report  "Object Server 01:  User 'XXXXX' is not authorized to insert a record in table 'SYSCLIENTACCESSLOG'. Request denied. " and same issue other features as well like while crating quotation from requisition. Reports are other feature are working with admin rights.

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    101,166 Moderator on at

    Does your user have "System user" role? All users should have it.

  • kvnkk Profile Picture
    800 on at

    Yes.. Every user in application have the "system user" role.

  • WillWU Profile Picture
    22,363 on at

    Hi kvnkk,

    Have you set the CLIENTACCESSLOGLEVEL to 1 or 2 ?

    There are two log levels that can be enabled in the UserInfo Table.

         a) High Level. Value of 1

         b) Detailed Level. Value of 2

    After running the following SQL statement in AX database, the user will have to restart his/her AX Client for the logging to start.

    update USERINFO set CLIENTACCESSLOGLEVEL = 1 where id = ''

    or

    update USERINFO set CLIENTACCESSLOGLEVEL = 2 where id = ''

    Hope this helps.

  • kvnkk Profile Picture
    800 on at

    Somehow, reports are working by changing the roles and by assign "processreport" method under server method node of privilege.  

    Still we are getting same error with one user while "creating Purchase order from Release approved purchase requisitions."

  • Suggested answer
    nmaenpaa Profile Picture
    101,166 Moderator on at

    Assuming you don't get these errors when using the out-of-the-box roles, I suggest you compare your role to the standard roles to spot some difference.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    303,988 Super User 2026 Season 1 on at

    Hi Kvnkk,

    Check where this SysClientAccessLog table is used in standard security. Have you considered adding this table with grant permissions on the roles for these users?

  • zhifeng Profile Picture
    Microsoft Employee on at

    Does that specific user has same role with others while "creating Purchase order from Release approved purchase requisitions."? if not , grant same role with other can work?

  • kvnkk Profile Picture
    800 on at

    As it is system table we are unable to add this table under security privilege. To give specif permissions

  • kvnkk Profile Picture
    800 on at

    @  Kevin, :- "creating Purchase order from Release approved purchase requisitions."?  is working with only with admin rights and we are  keep testing with different roles.  

    @Nikolaos Mäenpää:- sure we will try your suggestion

    @André Arnaud de Calavon :   As it is system table we are unable to add this table under security privilege. To give specif permissions

  • André Arnaud de Calavon Profile Picture
    303,988 Super User 2026 Season 1 on at

    Hi Knvkk,

    Technically, it was possible for me to add this table as reference on the privilege by just typing the name. However, I don't have any use case how to test it. Can you also try to manually type the table name?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 653

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 493 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 317 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans