samedi 27 juin 2015

how do I create a user for internet and administration on MS SQL?

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