I am trying to determine the appropriate premissions settings for new SQL users.
I have a SQL database that is serving as a small datawarehouse. For the past year or so there have only been 2 people using it. There are a few new people who are going to be learning SQL (first time users) who will be starting on the databse next week. We do not have any system like Cognos or Business Objects...they are going to need to learn SQL.
I want them to be able to:
write select statements on database tables
create temp tables, and do anything with them (insert, update, delete)
create new stored procedures on any database
update existing stored procedures (I know this is a risk because they could delete stuff, but we do take backups...it will be more of a pain if we limit them from doing this)
etc...stuff like that...
What I want to AVOID is:
updates to existing database tables
deletes from existing database tables
changes to any indexes
what would be the best way to set permissions for these new users to they basically have full access to everything, but can't do any serious damage?