Solved

Dynamics GP 2010 - Remove Old Users Imported From Version 9.0

Posted on 2014-01-31
1
658 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 500 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

734 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