Hi,
I have a development user that is semi proficient is simple sql, and getting better. this individual develops queries in the test environment where he has dbreader rights. once he is satisfied with the query he submits it to me, I run it in live db and copy and paste the results, which can be a number of tables, to excel and return it to him. to eliminate the requirement of my involvement and to allow Devo quicker access to results in response to data requests I am considering giving him dbreader access to the live database and am concerned that he will accidently write a query that eats all sql server resources or starts locking processes.
Has anyone dealt with this situation and if yes how, and were there any gotchas?
===========================
Mendy Sudranski
IT Manager
Manhattan Theatre Club
311 West 43rd Street - 8th Fl
New York, NY 10036
Phone: (212) 399-3000 ext. 4105
msudranski@mtc-nyc.org