How to add rights for user

Allerlei tweaks voor een SQL Server

Moderator: Theet

Theet
Posts: 202
Joined: Mon 27 Sep 2010, 16:35

How to add rights for user

Post by Theet »

1) Open SSMS
2) Connect in object explorer the database with sa account
3) Change in "Security tab - Logins - username to change rights - Properties - Securables" and add/remove rights
4) Re connect database with user which is your default user to connect the database