Search the Blog

Monday, August 5, 2019

Rad only access to new user Sql Server 2017 step by step

when we require to prevent the access to a user for specific tables
Following steps we help to understand  the concept


Step 1:-
     Login to SQL Server - SSMS via admin rights


Step 2:- Object explorer in Right hand side  and click on security



Step 3:- Right click on security, Then click on new Login

Step 4:- Create Login Name and Select Sql Authentication, Set password, Select database

Step 5 :- Select Server Rule and select access as public

Step 6:-  Select User mapping
Step 7:- Select
Step -8:- Select access grant
Step 9:- Grant permission via query
Step 10:- Close your SQL Server Management Studio SSMS and again login.
          New user will have the access rights of only one table and has only read only rights


No comments:

Post a Comment

Translate