KTL SOLUTIONS

Deleting Dynamics-GP Users in version 10

Share this post

Sometimes you will have an orphan user in Dynamics-GP that you cannot delete the user.  You look in SQL and see that the login doesn’t exist and you also check the database and the user is not associated with the database.  To remove the users

  1. log into SQL Studio Manager
  2. Create a new query window
  3. Set the database to DYNAMICS
  4. Execute the following scripts
    •     DELETE DYNAMICS..SY01400 WHERE USERID = ‘<User_name>’
     
       
    •  
          DELETE DYNAMICS..ACTIVITY WHERE USERID = '<User_name>'
       
      •  
     
       
    •  
           DELETE DYNAMICS..SY10000 WHERE USERID = '<User_name>'
       
      •  
     
       
    •  
          DELETE DYNAMICS..SY60100 WHERE USERID = '<User_name>'
       
      •  
     
       
    •  
          DELETE DYNAMICS..SY10500 WHERE USERID = '<User_name>'
       
      •  
     
       
    •  
          DELETE DYNAMICS..SY10550 WHERE USERID = '<User_name>
       
      •  
     
    6.  
 



		
  




Tags
365 2013 2015 2016 accounting BI blog Business Business Intelligence Cloud CMMC CRM Data Development Dynamics Dynamics 365 Dynamics CRM Dynamics GP ERP Excel Government Contractor GP How To ISV KTL KTL Blog KTL Solutions Management Microsoft Microsoft Dynamics Microsoft Dynamics CRM Microsoft Dynamics GP Office 365 Power BI Project Project Management Reports Sales Security Solutions Technology tools User User Conference Webinar




















 
Related Posts



		

























Checking Your CMMC Progress			



 
Written by Alec Toloczko With Cybersecurity Maturity Model Certification (CMMC) requirements on the horizon, it’s crucial for organizations handling Controlled Unclassified Information (CUI) to adhere

Read More »		
  April 10, 2024