Forum Discussion
Remove leavers/users in SQL possible?
Hi all
We're cleaning up our licenses and i found a bunch of users, that have still a role assigned but do not work anymore in our company.
What did I do? I ran this query, this gave me all the users that are somehow on the Database.
select u.UserName, r.RoleName, r.Description, c.Path, c.Name
from dbo.PolicyUserRole pur
inner join dbo.Users u on pur.UserID = u.UserID
inner join dbo.Roles r on pur.RoleID = r.RoleID
inner join dbo.Catalog c on pur.PolicyID = c.PolicyID
order by u.UserName
A couple of them are not anymore working.
Is there a way to remove this users via another query or have i to remove them manually from the Power BI Frontend?
Many thanks
Brani
1) Remove user permission from reports (of folders) is not necesenary, if these peoples not working in company, then (I hope) their AD acccount are disabled or removed, and they cannot access.
2) Any modification in ReportServer database is not recommended, and not supported.
You can remove old users manually from GUI, or you can remove using REST API.
