How to set password to Table in order to restrict access in SQL Server

Question

Hi I have a team of programmer who are accessing database for development I have one table on which i want to restrict that no user can access it without the password how it can be achieved

Azim · Accepted Answer

Please refer these links for restricting access to Tablehttpstackoverflowcomquestions7970611restricuseraccesstotableusingsqlserver2008httpmsdnmicrosoftcomenuslibraryms173724aspxUSE AdventureWorks2012DENY SELECT ON OBJECTPersonAddress TO RosaQdMGOhttpstackoverflowcomquestions5623519sqlserverpermissiononapertablebasis

How to set password to Table in order to restrict access in SQL Server

Company

Explore

Follow us

Contact Us