Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Deleting Users

Deleting Users

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

We have a client that is cleaning up old users in PDK. When they try to delete the user they receive an unknown error message and it says to contact SQL admin.

When we review the users that we are trying to delete in SQL, each user is the owner of it's own schema. The schema is not tied to any other user. If we make another user (dbo) the owner of that schema, we are able to delete the user.

We ran the Mass Drop User Schemas script found on PartnerSource, but it did not remove the user's schema.

If I go into the schemas and manually delete the user schema and then attempt to delete the user in PDK, I receive the following error:

Unhandled script exception:
[Microsoft][ODBC SQL Server Driver][SQL Server]Count not find stored procedure
'DYNAMICS.dbo.PDKsp_GetNumRegisteredUsers'

Any suggestions on the best way to resolve?

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Deleting Users

Well the error is self explanatory, you are missing stored procedures. A way to validate this is first make a backup of your environment, make sure everyone is out then you can open the Dynamics Database Maintenance and recreate Stored Procedures / views and Triggers for the PDK product.

If that does not solve it, then try deleting the PDK product from your test and re-install it.

Other tasks you can do is going to Tools > Maintenance > SQL and choose the PDK product, select all tables and drop/create all autoprocedures.

But make sure you have a backup, don't risk it.