March 14, 2017

How to assign permission for database to user in SQL Server 2012

How to assign permission for database to user .

First you need to Connect with database engine in SQL server

Then go to security option after databases

Then expand  users and select user.

then You need to go to user mapping tab.

Tick  to yes for your selected database to assign permission .

Then select permission.



Thanks for watching this clip.