Good Morning,
We have upgraded one of our environments from SQL2000 to SQL2005. There are several users (Billing System and Reporting) that need the ability to view the code within views in a database...but we do not want them to be able to alter it. We're trying to keep the environment secure...but then need to be able to do their jobs.
Is there a way to allow them to see the properties of views or script them (Create or Alter) to a new window or the clipboard without giving them ddl rights or more permissions than then need? They could then review the code to verify its accuracy and submit Change Requests through a controlled process.
Thanks,
Sean.