Solved

GP 2010 Upgrade - Ok to Delete Old Users?

Posted on 2013-05-13
4
362 Views
Last Modified: 2013-05-20
I upgraded a client to GP 2010 from GP 9.0 and in doing so, elected not to transfer over the security settings.  New users were created for GP 2010 and are currently being used.

I would like to remove the old users from the database.  Is there any reason for me not to remove the old users?  Can I remove them via MS SQL or do I need to do something special via GP 2010?

Thank you!
0
Comment
Question by:TacomaVA
  • 2
  • 2
4 Comments
 
LVL 18

Expert Comment

by:Steve Endow
ID: 39163499
Hi,

I can't think of any technical reason why you would need to retain the old users in GP.  The only thing that comes to mind might be some type of audit requirement that would require you to retain the accounts and perhaps disable them instead of deleting them--but I am not personally aware of any such standard audit requirement.

If the old users are still listed in GP, I would recommend deleting them through the GP user interface if you don't have a ton of users.  This would remove them from the GP security tables and remove their SQL user records from all of the SQL databases at the same time.  It's simple and clean, although a bit tedious to delete them one at a time.

If you have 75 or 100 or more users, then I could see doing it via SQL.  If you use SQL Management Studio, you'll need to remove the database users, remove the server logins, and then delete the user records in the GP database(s).

Looks like there are user ID related records in DYNAMICS in SY01400, SY01402, SY01403, SY01404, SY01600, and several others.  So it will take a little bit of up front work trying to figure out all of the tables that you would need to clean up.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%USERID%' ORDER BY TABLE_NAME


Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 

Author Comment

by:TacomaVA
ID: 39168359
Thanks Steve.  I attempted to delete one of the old users via GP 2010, which worked, but I received a message notifying me that the user did not have a SQL login.  I opened SQL Management Studio and the user is still listed under Security -> Users and they have an entry in the Schema folder as well.

Can I delete the user and schema entry via SQL Management Studio without causing any harm?
0
 
LVL 18

Accepted Solution

by:
Steve Endow earned 500 total points
ID: 39168763
Hi,

Sorry, I think I jumped to a conclusion in my initial answer.

Did you move to a new SQL Server as part of your upgrade?

If so, and if you did not run the SQL scripts to specifically migrate your GP users to re-create them on the new server, then they are likely orphaned.

They will appear as the same user under the databases, but they will have behind-the-scenes SSIDs that are different from the SQL logins (because they came from the old server).  They are essentially orphaned security records in SQL Server.

Based on what you are describing where you get an error trying to delete the user from wihtin GP, it sounds like this is the case.  

If so, then I believe you will need to do both: delete users from GP, then manually clean out the SQL user records from each database.

Let me know if that sounds like the situation you are seeing.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified IT Professional
0
 

Author Closing Comment

by:TacomaVA
ID: 39181771
Thanks Steve - I did not transfer over the users.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
crm 2016 on cloud 5 84
Outlook Condational Formatting - Flaging Items by Age 1 271
Fetch XML Unions? 3 478
Microsoft Dynamics GP 2015 - Vendor Term Discount Smartlist 2 41
This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now