Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Micros 3700 "micros"."emp_password_def"

Status
Not open for further replies.

Menon181

Programmer
Aug 27, 2015
13
IN
Hi,
Is there any command available to update emp_pwd in "micros"."emp_password_def" table.

Thanks
M@non
 
If you need to login into pos it is easier to activate the "Micros Classic Password Security" in Restaurant and log in via ID.
 
It is possible to set the password value using the same one way encryption and salt as Micros / Oracle uses but as AndreasZ stated, if you just need to be able to get into POS and reset the password enable classic security, update the password, and re-enable.

If you need a way to sync employees and passwords into Micros without using active directory, that is also possible but more complicated.
 
@ Netvoid ,

Thanks for the reply and please share your email ID , so we can discuss in detail.



 
@NetVoid

Ive been able to workout that in 5.7 the password field in the db is the encryption, followed by the salt, followed by the hash. However there is something padded after the hash.
Any can advise how to generate this full password field outside of Micros?

Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website
 
I've also found that if you know the password hash of one user you can copy it to another user and then you can login with their username. A bit dodgy.

Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website
 
@CathalMF, the better way is enable windows integrated logon.
Thanks for all your valid inputs..

Regards
Menon
 
Welcome to email me for full sample code inetvoid@gmail.com ...

 
@NetVoid - Email Sent.

@Menon - Yes enabling the integrated login makes logging in easy, but just requires you to issue all your staff with server credentials if you want to have a proper audit of what people were doing.

Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top