Adding a role to all users within Dynamics GP using an SQL statement.

(0) Share

Report

Posted on by Community Member

Hey all...

Is there a way to add a particular role to all users within my Dynamics GP setup via a SQL script/statement/query? I've been a googling, but have not found any success. Any help would be appreciated.

Thank you in advance.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi,

I am not sure how this can be done through SQL but if its just one role which you wanted to assign to all users, just write a macro which will be faster and correct.

Was this reply helpful? Yes No
Suggested answer

Ian Grieve 22,784 on at

Like (1)

Report

A SQL update would be possible as there is a table which holds the link between the user table and the Security Roles table, but updating in this way is not recommended as it is easy to corrupt the table.

A macro might not be simple due to the scrolling window containing the tasks which can be assigned to the user.

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

Yeah, can be done through SQL.

Was this reply helpful? Yes No
Suggested answer

Victoria Yudin 22,769 on at

Like (0)

Report

Another option may be to just add the permissions to the DEFAULTUSER role, which every user has.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Hi JP,

I've done this by updating the SY10500 table which is the table that holds the Roles Assigned to Users. Here's my understanding of the security tables:

SY09000 --Task Master

SY09100 --Role Master

SY09400 --Security Object Resource Descriptions

SY09200 --Alt/Mod forms and reports ID Master

SY10000 --User Security (this is a VIEW)

SY10500 --Roles assigned to Users

SY10550 --Alt/Mod ID Assigned to Users by Company

SY10600 --Tasks assigned to Roles

SY10700 --Operations assigned to Tasks

SY10750 --Operations assigned to Default User Task

SY10800 --Alt/Mod F&R asigned to Alt/Mod report ID

SY60100 --User Access

syCompanyImage -- Company Images Blob Table

syReportTemplate --Report Templates Blob Table

Kind regards,

Leslie

Was this reply helpful? Yes No