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
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