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]
           ([CompanyID]
         ,[Username]
         ,[Rolename]
         ,[ApplicationName]
         ,[CompanyMask]
         ,[CreatedByID]
         ,[CreatedByScreenID]
         ,[CreatedDateTime]
         ,[LastModifiedByID]
         ,[LastModifiedByScreenID]
         ,[LastModifiedDateTime])
   VALUES
           (2
         ,'yourAccountName'
         ,'Administrator'
         ,'/'
         ,0xAA
         ,'B5344897-037E-4D58-B5C3-1BDFD0F47BF9'
         ,'00000000'
         ,'2010-07-27 17:25:00.000'
         ,'B5344897-037E-4D58-B5C3-1BDFD0F47BF9'
         ,'00000000'
         ,'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

Ready to take your Acumatica experience to the next level? Whether you need customizations, integrations, or tailored solutions to fit your unique business needs, our team is here to help. If you found this SQL snippet useful for managing user roles and permissions, imagine what we can achieve together with a fully customized Acumatica setup.

Leave a customization request today and let’s build the perfect solution for your business. Your vision, our expertise—let’s make it happen!