web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How can I temporarily ...
Microsoft Dynamics GP (Archived)

How can I temporarily disable/inactivate specific users from Dynamics GP, preventing them from logging in?

(0) ShareShare
ReportReport
Posted on by Gillian Berry 210

I need to temporarily disable/inactivate certain users, preventing them from logging in during system maintenance procedures. However, I still have 5+ users that will need to be able to get into the system. Those 5+ users do not have special rights to the databases like an "sa" account would, therefore putting the databases into "Single User Mode" or "Restricted User Mode" won't work. I've checked the sy01400 table and don't see a field that represents status, which is typically the case with most apps. So I'm welcoming any other suggestions and thanks in advance to anyone who can provide help!! I'm hoping there's another table I can use that would help to accomplish this that perhaps I didn't think of :)

*This post is locked for comments

I have the same question (0)
  • Hammam Diab Profile Picture
    Hammam Diab 230 on at

    in the users form there's a checkbox field called enabled. uncheck the box and they won't be able to login

  • Gillian Berry Profile Picture
    Gillian Berry 210 on at

    My users screen doesn't have anything about enable. I'm on version 10.00.1502 and only have the following fields on the user form: userID, user name, password, confirm password, classID, home page role, facilityID and then advanced SQL server security options for the password. Thoughts???

  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at

    In the User Access window, uncheck the access to company.

  • Gillian Berry Profile Picture
    Gillian Berry 210 on at

    Indeed that would work. However, we have 11 companies and each user is assigned to one or more different companies. So I'd need a way to put back each of those users with the correctly assigned companies. I'm not sure how that would be accomplished???

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Gillian, get Rockton's GP Toolbox. (www.rocktonsoftware.com/products.aspx) It has a feature that allows a system admin to lock users out of specific companies or all companies while maintenance is being performed.  The Toolbox is about $200 and includes a bunch of other useful tools.

    Hope this helps,

  • Gillian Berry Profile Picture
    Gillian Berry 210 on at

    I'll have to look into that. But there's really no easy way in SQL to disable users?

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    The Professional Services Tools Library also has this feature, but both of these options are for all users in a database.  Gillian, what kind of maintenance are you performing where some users can go in, but others cannot?  Or would disabling by database/company be enough?

    Jeganeedhi, I would be very careful with using and recommending your suggestion - when you uncheck a user's access to a company, it also clears all the security already set up for that user/company combination.  Unless you are going to import or copy the security settings back, this could be a major problem when you re-enable those users.

  • Gillian Berry Profile Picture
    Gillian Berry 210 on at

    They're performing year end close and don't want accountants in the system working and then obviously writing to the database. So the finance management team will need to log in to perform the closing tasks while all other staff is to be locked out.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Ah!  I guess I would not typically consider this 'system maintenance'.  :-)  There is really no good/easy way to accomplish this.  What I typically see is a combination of "training/instructions" (ie, "no more transactions for 2010" communicated to all users) and closing the periods on the Fiscal Period Setup window.  The people making adjustments to the year will need to save their adjustments in batches, then open the periods and post them, and re-close the periods.

  • Gillian Berry Profile Picture
    Gillian Berry 210 on at

    I think what also might work to ensure users cannot get into the system at all period is to alter their logins in the SY01400 table by adding an "*" in the front of each userID that shouldn't be in the system. Then after year end close is complete, removing it. Is there any reason this wouldn't be effective and safe???

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans