Microsoft Dynamics GP (Archived)

Using PSTL without SA - Dynamics GP2015 and up

(0) Share

Report

Posted on by Community Member

Hello all,

Is anyone aware of how to create a GP user with the privileges to use Professional Tools Services other than sa?

What about modifications to DYNSA?

All answers are appreciated.

Thank you,

Donnnette

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

L Vail 65,271 on at

Like (1)

Report

If you assign the Server Role of sysadmin it will give them everything they need to run PSTL.

Kind regards,

Leslie

Was this reply helpful? Yes No
Shahid.Ahmed 170 on at

Like (0)

Report

Hi Donnette,

Surprise to see that DYSA do have rights on PSTL at your end. however , I checked at my side. User "DYNSA" already have access on PSTL and it is also showing in Navigation bar. Is it appear on your Navigation bar area?

See the attached screen shot.

Was this reply helpful? Yes No
Verified answer

Derek Albaugh on at

Like (1)

Report

Hello Donnette,

The information given is correct. Microsoft Dynamics GP is hard-coded to verify whether you're logged on as 'sa' or 'DYNSA' when attempting to access and use any of the tools in the Professional Services Tools Library (PSTL).

As a test, I setup a custom role and task for security to everything under the 'Technical Services Tools' (PSTL), and even though the user could access the PSTL window, they get a message: "You must be logged in with sa or sql permissions to utilize this Utility."

If I gave this user the 'sysadmin' SQL role, which is the equivalent of the 'sa' login, then the user could access everything in PSTL. Next, I tried removing 'sysadmin' and giving the user the 'securityadmin' and 'dbcreator' SQL roles, which is what DYNSA has, but the user got the same message as above, so the Dynamics GP application may be hard-coded to look for DYNSA and sa, then any other user with 'sysadmin' permissions on the SQL side, in order to be able to actually use the PSTL tools.

Thanks,

Was this reply helpful? Yes No
Janeece Moreland 270 on at

Like (1)

Report

This worked and I really appreciate you!

Was this reply helpful? Yes No