• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 525
  • 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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