Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Dynamics GP 2010 - Remove Old Users Imported From Version 9.0

Posted on 2014-01-31
1
Medium Priority
?
678 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

578 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