RES 3700 - Recover Micros login ID from database

Due to the nature of the restaurant business there is generally a large amount of staff turnover. This can sometimes lead to senior level access to the Micros POS system being lost of just not passed from one person to another.

Thankfully its easy to get back through some SQL commands.

NOTE: If you are uncomfortable with performing any of these tasks contact someone who will be able to follow these instructions or I may be able to perform these tasks remotely for a fee. See my email address at the top of this page if you need to contact me.


Classic Security:

For this we need access to DBISQL. If you don't know what this is read my quick overview of it here.

After logging in run the following statement:

Select first_name, last_name, pc_appl_id, id, effective_to from micros.emp_def

This will return to you all of the employees in the database with their login information. Select the appropriate information for the previous person with full system access.

PC_APPL_ID = Login ID for the micros applications on the server eg Pos Configurator

ID = Login ID for the till system. Usually their employee card number.

EFFECTIVE_TO = If the employee was setup to expire at a particular date then this is the date. If it is before today then you will not be able to login using this ID.

Enhanced Security:

If you have enhanced security which requires a username and password to login to the micros applications follow the below steps.

First you will need to perform the above steps for Classic Security and get a valid PC_APPL_ID.

Next you want to disable the Enhanced Security so that you can login using just the PC_APPL_ID number.

Execute the following update in DBISQL to disable the enhanced security.

update micros.rest_def set ob_classic_security = 'T'

Commit                                                                  

Now open the Pos Configurator and it will allow you to login with just the pc_appl_id number.

As soon as you login execute the following statement to re-enable the enhanced security.

update micros.rest_def set ob_classic_security = 'F'

Commit                                                                  

Now open the employee list and you can now set yourself a new Username and Password.

Hope this helps you out.