SQL Server Performance Forum – Threads Archive
db_owner role on reportserver dbthe 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…
I don’t see a problem in move, as you can simply restore. Fyi refer tohttp://technet.microsoft.com/en-us/library/ms159093(SQL.90).aspx link. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Sorry if i didn’t ask my question right .
is the good idea to create user objects (table , procs etc) on reportserver database?