Access Denied to Table when Creating/Posting Project Journal Transaction

(0) Share

Report

Posted on by Community Member

I am writing code to create and post Project Journal Transactions through an AIF Service. If I access the service using an "Admin" account, the process works. However, if I use an account with minimum required access, I receive access errors. I've worked through and granted permissions for the numerous tables involved to a point, but I am stuck at the JournalError table. I've granted access there as well, but that alone doesn't work. My guess is that whatever tables are related through "Common" are causing this roadblock, but I am not sure what they might be that I haven't covered already.

Any suggestions?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Dick Wenning 8,705 Moderator on at

Like (0)

Report

can you table browse the table in the AOT, with that user account?

an other test , can you do this process with this user in an ax client?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

That particular user account does not have access to the development workspace; nor does it have access to Projects.

The access for Project Fee Transaction Journals is granted only through the AIF service.

I had been going through the table access one-by-one using error messages on the service call, but I've hit a road block at the JournalError table.

Was this reply helpful? Yes No
nav 180 on at

Like (0)

Report

Hi Steve,

Do you get an error when trying to create the transactions? Is the table involved a Supertype/SubType table? If so then you may need to grant access to additional tables. Have a look at the following blog post.

axbytes.blogspot.co.uk/.../security-issue-for-tables-with.html

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Steve,

What version of AX are you using? What is the literal error messages you get?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Cannot edit a record in Errors (JournalError).

Access Denied: You do not have sufficient authorization to modify data in database.

JournalError has a relation to "Common," which is where I expect the access error is occurring, since the service has Create privileges for JournalError.

The service is also apparently missing privileges for some other table required for posting the journal.

Was this reply helpful? Yes No