Accidentally system administrator privilege has removed

(0) Share

Report

Posted on by Syed_Faisal

815

Hello,

My login and there was another login has System Admin & System Customiser security role privilege. When i changed Business unit, unfortunately I am unable to login and even other tool.

How to restore login privilege ?

8737.User-Setting.PNG

Regards

Faisal

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (1)

Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

Hi,

You cannot restore role if these are changed. You need to ask someone else to assign you system admin role again.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report

Hi Sayed ,

Its default behavior , changing business unit for any user will be removed security role. So you need to login CRM with another System Admin user and assign the security role to you .

Was this reply helpful? Yes No
Syed_Faisal 815 on at

Like (0)

Report

Thanks for answers, unfortunately, there is no other user has access and it was happen on test server.

Was this reply helpful? Yes No
Suggested answer

Emre GULCAN 2,379 on at

Like (1)

Report

Hi Syed,

I faced same issue last year, one of BA inside my team changed only one crmadmin's role as sales people. ı tried to login with XrmToolbox with my crmadmin account (old admin, new salesperson) and use "User Roles Manager" plugin and try to change my crmadmin role to "system administrator" and it worked (it was miracle :))

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Hi Sayed ,

I can see you are using on-premise , so you can directly update database table.

Below is the Query I prepared for you, you need to just execute in organization database after replace the first name where I have given my name.

Declare @RoleID varchar(50) Declare @RoleName varchar(50) Declare @BuisinessunitName varchar(100) Declare @UserId varchar(50) select @BuisinessunitName =BusinessUnitIdName,@UserId=SystemUserId from SystemUser where FirstName ='gautam' select @RoleID=RoleId,@RoleName=Name from Role where Name= 'System Administrator' and BusinessUnitIdName = @BuisinessunitName update SystemUserRoles set RoleId=@RoleID where SystemUserId =@UserId

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

Hi,

First thing this is a default behaviour, Second there should be another admin role otherwise CRM won't allow to remove the admin security role normally, so check who is other user and he can reassign your role back.

Was this reply helpful? Yes No
Syed_Faisal 815 on at

Like (0)

Report

Hi Gowtham,

Thanks for the reply, as instructed i did same. After run the Query i got this message in SQL "(0 rows affected)"

When try to login to CRM, Getting this below error.

" An error has occurred.

Try this action again. If the problem continues, check the Microsoft Dynamics 365 Community for solutions or contact your organization's Microsoft Dynamics 365 Administrator. Finally, you can contact Microsoft Support.

I also have rebooted the system and still it is same.

Was this reply helpful? Yes No
Syed_Faisal 815 on at

Like (0)

Report

Hi Emre,

I tried with XRMToolbox but no luck for me.

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (1)

Report

Hi Sayed,

Run the query again and check userid you are getting or not.

Declare @RoleID varchar(50)

Declare @RoleName varchar(50)

Declare @BuisinessunitName varchar(100)

Declare @UserId varchar(50)

select @BuisinessunitName =BusinessUnitIdName,@UserId=SystemUserId from SystemUser where FirstName ='gautam'

select @RoleID=RoleId,@RoleName=Name from Role where Name= 'System Administrator' and BusinessUnitIdName = @BuisinessunitName

Select @UserId, @RoleID

update SystemUserRoles set RoleId=@RoleID where SystemUserId =@UserId

Check the firstname you are giving correctly.

Was this reply helpful? Yes No
Syed_Faisal 815 on at

Like (0)

Report

Hi Goutam,

Thanks for the reply, i run the query. PF screenshot.

Still getting same error.

Was this reply helpful? Yes No