sql - Removing SSRS security for a single person -
we have employee left company, , have bunch of ssrs reports has access to. there way remove of reports @ once, or have go 1 one?
you can delete user reportserver database.
then, user can no longer verified, , login becomes impossible.
ps: backup reportserver database first, in case...
delete [reportserver].[dbo].[policyuserrole] userid in ( select userid users username ='blabla' ) delete users username ='blabla'
Comments
Post a Comment