Solved

sql server table access restriction

Posted on 2011-03-20
2
466 Views
Last Modified: 2012-05-11
hello ,
i want to create table in sql server but restrict access to sa only
other users can only insert in this table
0
Comment
Question by:AhmedHindy
  • 2
2 Comments
 
LVL 14

Expert Comment

by:Daniel_PL
ID: 35176533
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
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 500 total points
ID: 35176726
Additionally you can grant each user in database isert priviledge to your table explicitly. You may find this option more comfortable.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now