MS Dynamics User Security

ramziabk
ramziabk used Ask the Experts™
on
I'm trying to assign user to secuirty to MS dynamic users.

I created the user and gave the user access on the database. Entering the User security and selecting any user is giving me the error:

UserID is being edited by another user.

I ran the query: Select * from Activity on database dynamics and only my username is connected? So what the hell is going wrong?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Hi,

Check the following tables to see if there is a lock record for user security:

SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801

SELECT * FROM tempdb..DEX_LOCK
SELECT * FROM tempdb..DEX_SESSION

If you find a record that looks like it is causing the lock, have all users log out of GP and then delete the problem record.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional



Author

Commented:
Dear Steve,

Thanks for your reply. However non of the above mentioned statements retirieves any record!!! and still when accessing the security access, I get the same error:

UserID is being edited by another user

Thanks
Ramzi

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial