Best Practices for Reporting Databases.

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  September 21, 2007 at 1:22 pm

  #178489

  Hi ,

  can any body pls confirm what are the best practices for databases used only for reporting purposes ,our requirement is users should also be able to create views on this database and should be able to pull the reports by individual or by web tool.

  Thanks.. 

• Yelena Varshal

  SSC-Dedicated

  Points: 34286

  More actions

  September 21, 2007 at 1:42 pm

  #735360

  Let them create views in another database that reference your reporting database. Give people  read-only access.

   

  Regards,Yelena Varsha