If you're SQL.. Simply run an quick UPDATE statement on the USERFILE table:
Update UserFile SET UserDisabled = 1, Number20 = 999 where DCDUserID <>
'manager'
Nobody can login now except the Manager. Setting Number20 to "something"
allows you to undo the update quickly (potentially you have legit user
accounts that were previously disabled)
When you're done:
Update UserFile SET UserDisabled = 0, Number20 = 0 where Number20 = 999
If you're Progress, you can still quickly and safely do this with SQuirreL.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
b_ordway
Sent: Sunday, June 02, 2013 1:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Easiest Way to keep users from logging in
The server was connected to its own switch, which was then connected to the
LAN.
We'd just unplug the network cable when we didn't want anyone logging on.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"McMullen, Travis" <tmcmullen@...> wrote:
Update UserFile SET UserDisabled = 1, Number20 = 999 where DCDUserID <>
'manager'
Nobody can login now except the Manager. Setting Number20 to "something"
allows you to undo the update quickly (potentially you have legit user
accounts that were previously disabled)
When you're done:
Update UserFile SET UserDisabled = 0, Number20 = 0 where Number20 = 999
If you're Progress, you can still quickly and safely do this with SQuirreL.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
b_ordway
Sent: Sunday, June 02, 2013 1:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Easiest Way to keep users from logging in
> keep everyone out while it runsWe used to do this to keep users out on another system...
The server was connected to its own switch, which was then connected to the
LAN.
We'd just unplug the network cable when we didn't want anyone logging on.
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"McMullen, Travis" <tmcmullen@...> wrote:
>few
> We are having some major issues with performance during the capture so we
> keep everyone out while it runs and while we correct and review journals.
> We capture on the last day and check it the following since it takes
> hours. If we have to rerun it, we don't want current month transactions to
> be captured.
>
> Travis L. McMullen
> ERP Specialist
> ComSonics, Inc.
> Harrisonburg, VA 22801
> Phone: 540-434-5965 x1274
> Toll Free: 1-800-336-9681 x1274
> Mobile: 540-435-1920
> Fax: 540-434-9847
> E-Mail: tmcmullen@...
>
>
> On Fri, May 31, 2013 at 11:15 PM, Chris Robisch <bluewine@...> wrote:
>
> > **
> >
> >
> > We don't keep anyone out as we capture for a period in the past after
> > ensuring all entries are correct for payroll and such.
> >
> >
> > ----- Original Message -----
> > From: "subzerovi" <tmcmullen@...>
> > To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
> > Sent: Friday, May 31, 2013 8:11 PM
> > Subject: [Vantage] Easiest Way to keep users from logging in
> >
> > > We have had multiple issues with our Month End Capture process that
> > > requires us to keep everyone out of Epicor 9 with the exception of a
> > > accounting people.)
> > >
> > > Is there an easy way to do this? Can I use the Epicor Administration
> > > Console to disable and re-enable all the accounts?
> > >
> > >
> > >
> > > ------------------------------------
> >
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > > have already linked your email address to a yahoo id to enable access.
> > > (1) To access the Files Section of our Yahoo!Group for Report Builder<http://groups.yahoo.com/group/vantage/files/>
> > and
> > > Crystal Reports and other 'goodies', please goto:
> > > http://groups.yahoo.com/group/vantage/files/.
> > > (2) To search through old msg's goto:05/31/13
> > > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services goto:
> > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > > -----
> > > No virus found in this message.
> > > Checked by AVG - www.avg.com
> > > Version: 2013.0.3343 / Virus Database: 3184/6373 - Release Date:
> > >[Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>