Posted - 10/30/2013 : 19:10:40
When i send a DB to a customer, he/she has to be able to attach/detach the DB. Furtheron the DB needs to have a user login for the enduser and i have to be able to run scrips to alter tables and add tables aso.
I have set the owned schemas to db_datareadeer and db_datareader. (I do not create one record per end user, may be i wil do this later.)
I do not know how to implement the other user/roles. I guess i need the 3 levels i mentioned?
1 administrator - able to alter the DB (tables/fiels/vieuws)
2 manager - able to attach / detach db
2 end user - read / write