Forum Discussion

Brani's avatar
Brani
Frequent Visitor
2 years ago
Solved

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 th...
powerbi
Report Server
SQL
  • josef78's avatar
    josef78
    2 years ago

    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.

Brani's avatar
Brani
Frequent Visitor
2 years ago

Hi  lbendlin 

From the Database "ReportServer". The default DB.

Best Regards
Brani

josef78's avatar
josef78
Memorable Member
2 years ago

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.

  • Brani's avatar
    Brani
    Frequent Visitor
    2 years ago

    Hi josef78

    Thanks for your reply. 

    Users are removed from AD, but we keep track of leavers. But they are still counted in the "Roles", i.e. "contant manager" etc. 
    So the solution is GUI or REST API 👍

    Many thanks / Beste Grüsse

    Brani