×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Update Micros 3700 "micros"."emp_password_def"

Update Micros 3700 "micros"."emp_password_def"

Update Micros 3700 "micros"."emp_password_def"

(OP)
Hi,
Is there any command available to update emp_pwd in "micros"."emp_password_def" table.

Thanks
M@non

RE: Update Micros 3700 "micros"."emp_password_def"

If you need to login into pos it is easier to activate the "Micros Classic Password Security" in Restaurant and log in via ID.

RE: Update Micros 3700 "micros"."emp_password_def"

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.

RE: Update Micros 3700 "micros"."emp_password_def"

(OP)
@AndreasZ,Thanks for the response..

RE: Update Micros 3700 "micros"."emp_password_def"

(OP)
@ Netvoid ,

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



RE: Update Micros 3700 "micros"."emp_password_def"

@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 http://www.microspostools.com/

RE: Update Micros 3700 "micros"."emp_password_def"

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 http://www.microspostools.com/

RE: Update Micros 3700 "micros"."emp_password_def"

(OP)
@CathalMF, the better way is enable windows integrated logon.
Thanks for all your valid inputs..

Regards
Menon

RE: Update Micros 3700 "micros"."emp_password_def"

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

RE: Update Micros 3700 "micros"."emp_password_def"

@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 http://www.microspostools.com/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close