702A - Reset training DB user

Epicor admin console

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, January 26, 2015 6:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 702A - Reset training DB user

 

 

All of our User ID passwords have expired on the 702a training database and we are not able to log in and expire them.  Is there another way to reset the passwords without downloading the training database again?  We were provided with the following SQL Query to expire the password but the query didn’t work.

 

Use [your DB name]

UPDATE UserFile

SET Password=''

WHERE DcdUserID='manager'

 

Or

 

Use Epicor905

Select * from Userfile

Where DcdUserID = ‘manager’

 

<!-- #ygrps-yiv-1786673696 _filtered #ygrps-yiv-1786673696 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1786673696 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1786673696 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1786673696 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-1786673696 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-1786673696 #ygrps-yiv-1786673696 p.ygrps-yiv-1786673696MsoNormal, #ygrps-yiv-1786673696 li.ygrps-yiv-1786673696MsoNormal, #ygrps-yiv-1786673696 div.ygrps-yiv-1786673696MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1786673696 a:link, #ygrps-yiv-1786673696 span.ygrps-yiv-1786673696MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1786673696 a:visited, #ygrps-yiv-1786673696 span.ygrps-yiv-1786673696MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1786673696 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1786673696 code
{
font-family:“Courier New”;}
#ygrps-yiv-1786673696 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1786673696 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1786673696 span.ygrps-yiv-1786673696cat
{}
#ygrps-yiv-1786673696 span.ygrps-yiv-1786673696ct
{}
#ygrps-yiv-1786673696 span.ygrps-yiv-1786673696HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-1786673696 p.ygrps-yiv-1786673696attach, #ygrps-yiv-1786673696 li.ygrps-yiv-1786673696attach, #ygrps-yiv-1786673696 div.ygrps-yiv-1786673696attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1786673696 p.ygrps-yiv-1786673696bold, #ygrps-yiv-1786673696 li.ygrps-yiv-1786673696bold, #ygrps-yiv-1786673696 div.ygrps-yiv-1786673696bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1786673696 p.ygrps-yiv-1786673696green, #ygrps-yiv-1786673696 li.ygrps-yiv-1786673696green, #ygrps-yiv-1786673696 div.ygrps-yiv-1786673696green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1786673696 p.ygrps-yiv-1786673696replbq, #ygrps-yiv-1786673696 li.ygrps-yiv-1786673696replbq, #ygrps-yiv-1786673696 div.ygrps-yiv-1786673696replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1786673696 p.ygrps-yiv-1786673696ad, #ygrps-yiv-1786673696 li.ygrps-yiv-1786673696ad, #ygrps-yiv-1786673696 div.ygrps-yiv-1786673696ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1786673696 p.ygrps-yiv-1786673696underline, #ygrps-yiv-1786673696 li.ygrps-yiv-1786673696underline, #ygrps-yiv-1786673696 div.ygrps-yiv-1786673696underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1786673696 span.ygrps-yiv-1786673696yshortcuts
{}
#ygrps-yiv-1786673696 p.ygrps-yiv-1786673696ad1, #ygrps-yiv-1786673696 li.ygrps-yiv-1786673696ad1, #ygrps-yiv-1786673696 div.ygrps-yiv-1786673696ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1786673696 p.ygrps-yiv-1786673696ad2, #ygrps-yiv-1786673696 li.ygrps-yiv-1786673696ad2, #ygrps-yiv-1786673696 div.ygrps-yiv-1786673696ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1786673696 p.ygrps-yiv-1786673696underline1, #ygrps-yiv-1786673696 li.ygrps-yiv-1786673696underline1, #ygrps-yiv-1786673696 div.ygrps-yiv-1786673696underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1786673696 span.ygrps-yiv-1786673696yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1786673696 span.ygrps-yiv-1786673696yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1786673696 span.ygrps-yiv-1786673696EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1786673696 .ygrps-yiv-1786673696MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1786673696 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1786673696 div.ygrps-yiv-1786673696WordSection1
{}
#ygrps-yiv-1786673696
_filtered #ygrps-yiv-1786673696 {
}
_filtered #ygrps-yiv-1786673696 {

font-family:Symbol;}
_filtered #ygrps-yiv-1786673696 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1786673696 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1786673696 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1786673696 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1786673696 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1786673696 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1786673696 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1786673696 {

font-family:Wingdings;}
#ygrps-yiv-1786673696 ol
{margin-bottom:0in;}
#ygrps-yiv-1786673696 ul
{margin-bottom:0in;}
–>

All of our User ID passwords have expired on the 702a training database and we are not able to log in and expire them. Is there another way to reset the passwords without downloading the training database again? We were provided with the following SQL Query to expire the password but the query didn’t work.

 

Use [your DB name]

UPDATE UserFile

SET Password=’'

WHERE DcdUserID=‘manager’

 

Or

 

Use Epicor905

Select * from Userfile

Where DcdUserID = ‘manager’