I am a knew to creating users on MS SQL. So Here is what I am trying to do.
I am a master user on the Database. I can create users and databases and whatever.
I want to create two more user
1) Administrator2: This user will execute all tasks or creating, dropping, modifying data, tables and procedures on the database. It would be the same as the db_owner, however this user CANNOT be able to drop the database. (My last admin dropped my database by mistake, I know not a very good admin).
2) WebUser: This user will be used by my application so it must be able to read, write, execute procedures, etc.
Is there a pre-made schema or something for me to achieve this? If not how can I achieve this?
I already know that I have to create Logins for the server access and users for the Database. But a good simple steps would be appreciated.
Aucun commentaire:
Enregistrer un commentaire