Is there a built in Role which I can grant to a user that allows them to do anything with the schema and the data, but not security and maintenance?
data_writer can add/update/delete, but iirc it doesnt allow
I want to be able to perform
- tables, views, sprocs
- indexes, FKs etc
- data inside tables
- full text catalogs
but not allow:
- dropping the db
- messing with the security settings
- messing with the backup/maintenance plans
- anything else that isnt related to the schema or data in it
Is this easily achieved?
Do I need to create a custom role for this? If so, what permissions do I need to assign it?