You’re offline. This is a read only version of the page.
295
The Dynamics user is located in table dynamics..sy01400. I delete a former employee from this table to remove access to GP. Are there any other tables from which this user must be removed?
*This post is locked for comments
That's an interesting approach. You might be able to create a business alert that when employee id gets 'inactivated' sends an email to IT group who is responsible for deleting user. This might help with compliance. I wasn't aware that SOX required this.........
The basic problem is how do you know if an employee is also a GP user? I don't think GP stores that kind of relationship anywhere in database. I guess you could store it in extender window or something......
Are all employees also GP users?
You could do a SQL trace - find out exactly what happens in SQL when a user is deleted and then mimic with SQL trigger or stored procedure..........
Just a thought........
Good Luck - let us know what you decide to do.........
Thanks, but we are trying to get the user ID removal automated for purposes of SOX compliance. Is that out of the question?
Merv -
Microsoft recommends using the Great Plains Interface to remove users. The interface will take care of all the back end SQL stuff. I think there are some other tables but users are not typically removed via SQL.
To remove via interface - login as 'sa' - go to - Tools > setup > system > user
select user and click delete........
Good Luck
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
