Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Dynamics GP 2010 - Remove Old Users Imported From Version 9.0

Posted on 2014-01-31
1
Medium Priority
?
675 Views
Last Modified: 2014-02-03
Hello,

I have several users within GP 2010 that are no longer valid.  We upgraded from GP 9.0 to GP 2010 and elected not to migrate the existing users (thus new users were created).  The old users remain inside GP and I would like to remove them if possible.

Going to Tools->Setup->System->User and deleting one of the old users results in an error message that reads "This user does not have a corresponding SQL login.  To create a SQL login, enter a password and choose save."  

Since the SQL login does not exist, I followed this Microsoft KB article http://support.microsoft.com/kb/919345.  The article says to run 'DROP USER <user>' against the DYNAMICS database and the company database.  When I execute the query, SQL throws an error that reads "The database principal owns a schema in the database, and cannot be dropped."  

Can I delete the schemas that are owned by the users that I want to delete and then execute the 'DROP USER <user>' query for each user that I want to delete?

Thank you
0
Comment
Question by:TacomaVA
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 39824467
"Can I delete the schemas that are owned by the users that I want to delete and then execute the 'DROP USER <user>' query for each user that I want to delete?"

I would rather change the Schema owner than drop is because it may contain some used objects and at least by doing this if anything gets broken do to missing priviledges they can be added later.

How to change schema owner - see below and check the script that does it for all objects per schema:

http://stackoverflow.com/questions/1146599/how-do-i-change-db-schema-to-dbo
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

885 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