When I am performing database maintenance, how do I disable logins so that a user (s) cannot log in while the maintenance is being performed?
You can build yourself a script substituting your users. Run the scripts in SQL. You will need sysdamin rights to do this.
To disable ‘MyUser’ login run this before maintenance
ALTER LOGIN MyUSer DISABLE
To enable ‘MyUser’ login run this after maintenance
ALTER LOGIN MyUser ENABLE
There is no command in GP that disable users although you could remove their access to companies.
Richard E. Wheeler 2013 MVP
MS Dynamics GP Support
www.rbsolutions.com Revered Business Solutions Ballston Lake, NY 518-877-0763 x10
You could use the Database Disabler tool in the PSTL (Professional Services Tools Library). It is free if you have GP 10.0 or 2010.
Victoria Yudin - Dynamics GP MVP (2005-2013)
Want to use Crystal Reports or SSRS with Dynamics GP? Check out GP Reports Viewer
Richard, that worked for 1 user...is that a SQL statement that will disable all users or do I have to set this up for all users 1 time and then execute the statement when I am performing maintenance?
Leslie, I just installed PSTL last month (after GPUG!!) so I will check out the database disabler tool
You have to build the script for each user to disable them and then again to enable them. How many users are we talking about here?
where type ='S' and is_disabled = 0
You could use this statement to help build a larger script if you have many users.
I tested this with PSTL (Database Disabler) and liked this option better...Thanks!
Great! I think now that the PSTL is free, this really makes sense.
Victoria, if you do not mind me asking what exactly does the PSTL do to disable the databases?
That is a great question.
According to the PSTL manual:
"This tool allows the “sa” user to disable any company database. Once the database is disabled, the company option is removed from the Microsoft Dynamics GP log in window. The company database can easily be reactivated."
So this sounds to me like it is "hiding" the company from the login screen. How this is done technically, I am not sure. Perhaps if someone reading this knows the answer, they could chime in on this.
The nice thing about this tool is that you can use it quickly, on one company at a time.
It does hide the company from the login screen. When I tested using PSTL Database Disabler,I logged in using a "test" id that I had set up. The test database didn't show as an option. I think "SA" is the only user that can log in. It happens instantly...When I wanted to enable logins for the test company, I just "unchecked" the test company from the PSTL D/B Disabler and was able to see the test company when I tried to log in..
I've read that you start recently with Duke University in an other post... Can I make you a suggestion : buy the Dynamics GP Toolbox from Rockton Software, this will tremendously help in your daily work. It also contains a function to 'put' the system in Maintenance mode, but allows you to choose other users aside of 'sa' to be able to do the maintenance in GP... It's not very expensive and you will not regret it.
The problem with most functions in PSTL is that they can only be used with 'sa' and only be executed if you're the only user in the system (which can make sense for some activities, but not all at my opinion).
-- Enjoy the Life+-+-+-+-+-+-+-+ Beat BUCHER Dynamics GP 2010R2 Business Analystwww.fti-ibis.com +-+-+-+-+-+-+-+
Beat, I am the SA and IT Analyst and I don't want others doing maintenance. I have front end and back end experience with GP ....other employees do not. I am playing it safe..
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13