how can deny user who has full rights to prevent some tasks.

Question

how can deny user who has full rights to prevent some tasks.

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 1

Create a user and then carefully study what rights that user needs. Then Give the rights accordingly. If you want the user to have Select rights for one DB, Grant the User rights to that DB. (Add the user to the DB) and give db_Datareader. If the user needs right to insert or update or delete on the whole DB, give db_DataWriter rights.

-Roy