Micros 3700 5.7 Locked Out

[AM_WG]

I was updating employee classes and it seems I may have locked out our Admin from pos configurator by accident. HELP! What tables and fields should I look at in SQL to fix this?

 

[Wildbar]

micros.emp_def and i think its accnt_disabled Need to update to 'F' for the user

 

[AM_WG]

Awesome, thanks. I will try that.

 

[AM_WG]

Yeah, it's not the user. It's the employee class that I accidentally removed the access for the super user class.

 

[AM_WG]

Turns out the emp_class_cfg_access.def table is empty at this site and not at others I've check. Looks like the table got crunched. Any ideas how to recreate this?

 

[AM_WG]

We were able to export the table from another location and import it into this one. Then fix the references in the DB to point to the records in the db. Thanks for the help.