Thanks for getting back to me.

What I meant was, if i set user a as the specified credential is it given  db_ddladmin role on the database automatically.

In answer to the question:

Out of interest, if you have administrated an SSRS server before, the reports seem to be neatly grouped within folders, therefore is it common to apply...

Also just found this online

select u.UserName, r.RoleName, r.Description, c.Path, c.Name

from dbo.PolicyUserRole pur

inner join dbo.Users u on pur.UserID = u.UserID

inner join dbo.Roles r on pur.RoleID = r.RoleID

inner join dbo.Catalog c on...

Look at the following tables in the reportserver DB and these should give you the information you need:

Execution log - Tells you who had run what. (this is defaulted to...

I have used power bi and SSRS side by side. My opinion is that most businesses see Power Bi as an evolution of reporting, and I will admit it is...

• This reply was modified 2 years, 5 months ago by  rogue1009.