SQL Server Performance

db_owner role on reportserver db

Discussion in 'SQL Server Reporting Services' started by raagi2000, Jun 19, 2007.

  1. raagi2000 New Member

    the users want to move the all the objects (tables , procs) pertaining to reports to reportserver database. is that a good idea ?

    According to us (DBA's) .. it is a central repository we not suppose to create/drop any objects at the reportserver database. Am i make sense ?
    i would say it is like for users getting access on master database to create/drop objects. but it is on the dev server.

    any comments on this...
  2. satya Moderator

  3. raagi2000 New Member

    Sorry if i didn't ask my question right .
    is the good idea to create user objects (table , procs etc) on reportserver database?

Share This Page