How to make yourself as Administrator in Acumatica with SQL

Hello everybody,

today I want to share some piece of SQL code that can help you to add yourself to Administrators group in Acumatica:

INSERT INTO [dbo].[UsersInRoles]
         ,'2010-07-27 17:25:00.000'
         ,'2010-07-27 17:25:00.000')

With this sql you can make yourself as administrator in Acumatica instance.

Also if you wish you can reset password of admin with following sql:

UPDATE Users SET Password = 'abc', LockedOutDate =null WHERE Username = 'admin'

and log in into Acumatica. There you can add to your account additional permissions

No Comments

Add a Comment