SQL right for user group

You can maybe have some problems to test some development because, the user who test this development have some Security denied access right.

You can put in Ax, your right like the user and remove your right Admin

But, what appens when you want recover your Admin right ?

  1. Ask to an other Admin, to give you the right
  2. You can change de SQL record

For the second solution, you must connect to the SQL database (throught Management Tool). Go to the database where you are (for exemple : MyCustomer_DEV) and go to the table

dbo.USERGROUPLIST

Find your login in the table, and change one of the right you have to “Admin”.

Relaunch Ax