Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • Last Modified:

sql server table access restriction

hello ,
i want to create table in sql server but restrict access to sa only
other users can only insert in this table
0
AhmedHindy
Asked:
AhmedHindy
  • 2
1 Solution
 
Daniel_PLDB Expert/ArchitectCommented:
All logins in sysadmin server role (including SA) are granted access to all tables in all databases.
After creating a table I suggest you to create your own database role, grant that role insert priviledge. Then add all your logins as database users in your newly created database role.

Some resources:
http://sqlserverpedia.com/wiki/Database_Roles
http://msdn.microsoft.com/en-us/library/ms189121%28v=SQL.100%29.aspx
http://www.mssqltips.com/tip.asp?tip=2038
0
 
Daniel_PLDB Expert/ArchitectCommented:
Additionally you can grant each user in database isert priviledge to your table explicitly. You may find this option more comfortable.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now