Finance | Project Operations, Human Resources, ...

GP AND SQL

(1) Share

Report

Posted on by sdcraig

366

I have a client who added an active Directory user to SQL and gave him DYNGRP access to Dynamics and the GP COMPANIES, he uses Azure Data Studio to query the data- he only wants him to see certain tables because of what he is working on (does not want him to see the GL, payroll tables etc) Is there a way to limit what GP Tables the users can access in SQL when querying data

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Talon Meyer 91 on at

Like (2)

Report

RE: GP AND SQL

They should revoke access to the DYNGRP role since that gives both read and write access.

Have them define a new database role in SQL Server with read only access to the proper database objects.

Was this reply helpful? Yes No
Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: GP AND SQL

As mentioned, DYNGRP gives access to all tables, views and stored procedures in the GP database that the user is assigned that role.

You could potentially use the RPT_ database roles. We use those for permissions for the Excel and SSRS reports to pull data from the GP databases. They work similar to the GP security roles in that, if you assign someone the RPT_HR Manager role, they'll only really have access to the tables/data that the role would normally need.

There's different ways you could potentially do something like this.

Thanks

Was this reply helpful? Yes No