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

Popular posts from this blog

java - Run a .jar on Heroku -

java - Jtable duplicate Rows -

validation - How to pass paramaters like unix into windows batch file -