Delete Users from Catalog table

• russell.young

  Mr or Mrs. 500

  Points: 555

  More actions

  September 13, 2012 at 1:27 pm

  #267759

  Can I use a tsql script to delete users from the reportserver Catalog table. I need to do a lot of clean-up for security reasons.

• Spiff

  SSCertifiable

  Points: 7826

  More actions

  September 14, 2012 at 2:39 am

  #1537682

  I wouldn't recommend it considering users are not stored in the Catalog table.

  Here is a link to a good series of blog posts explaining the Reportserver schema.

  http://sornanara.blogspot.co.uk/2011/05/ssrs-reportserver-database-tables.html

  Make sure you know exactly what you are doing before you start modifying and deleting tables in the report server DB.

  And then I 'd still recommend you don't do it.