MICROS 9700 Level Lock out

[themicrosman]

So some bonehead set all the users in the Property Programmer Class to be a level 9 instead of level 0. So naturally if I try to change it back I get "Unable to save. You do not have privileges to change a user to this employee Level:0" Does anyone know an SQL backway to change that? Otherwise we are kinda stuck getting access to a lot of stuff. Much Thanks to anyone that can share.

 

[CathalMF]

If you have access to the database you can modify the microsdb.Employee_class table to set the RwAcclvlid to 1 for your particular class.



Do you want some custom SIM scripts developed. Contact me via my website

http://www.microspostools.com/

 

[hosehead78]

Do you know if the Micros support username and password was changed, you could use that one, then change the position?

Also, the ObjectNumber is the same number as the Position Number for Micros. Example, if you have Cashier Group/Position number 11 - Cashiers, the Objectnumber for this is 11 in the microsdb.Employee_class table. This way you know you are changing the correct position.

Query below will list the Classes with their Position Names. Mind you this is for Micros 9700 database.

SELECT 
	ec.EmpClassID
	,ec.HierStrucID
	,ec.ObjectNumber
	,ec.NameID         -- Position Number
	,st.StringText     -- Position Name
	,ec.TransactionOptionBits
	,ec.IslOptionBits
	,ec.SupervisorOptionBits
	,ec.TimeclockOptionBits
	,ec.RmcAccLvlID
	,ec.RwAccLvlID
	,ec.DayMinutesOvertime
	,ec.PeriodMinutesOvertime
	,ec.PickupTransferStyle
	,ec.IsVisible
	,ec.IsDeleted

FROM MCRSPOS.microsdb.EMPLOYEE_CLASS ec

Join MCRSPOS.microsdb.STRING_TABLE st on st.StringNumberID = ec.NameID

Order by ec.NameID ASC

 

[themicrosman]

Thanks Hosehead. I totally blanked on using the support account. Maybe I just assumed it had been changed. But that got me in.

 

[hosehead78]

No Problem.