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

codeigniter - Fatal error: Call to undefined function lang() in CI Merchant using CardSave -

javascript - CasperJS/PhantomJS failing SSL handshakes on some sites even with --ssl-protocol=any -

c# - How to make tooltips show up when mouse hovers over data point -