Why records are creating automatically in sys_user_has_role when imporsonate with users ?

[Nickell73]

Hi All,

When I am impersonating to an user, around 47 records are getting created in sys_user_has_role table and assigning roles automatically. How to stop this automatic record creation.

Please help me.

Thanks in Advance!

[SN_Learn]

Hi @Nickell73 ,

Looks like some custom code is creating record in that table.

I would suggest to check the server codes which is inserting records in [sys_user_has_role] table.

Utilize the Script Debugger to check which scripts are running and then make the changes accordingly:

Script Debugger 

Mark this as Helpful / Accept the Solution if this helps