Solved

Insert Permissions For One Table

Posted on 2013-11-11
3
205 Views
Last Modified: 2013-11-12
I have just one table which I will need to give Insert permissions to for all Logins on my SQL Server Instance. Is there a way to do this globally or do I need to give explicit permissions to each Login by mapping them as a user and then giving them  insert rights on that table.

Thanks In Advance
0
Comment
Question by:VitaminD
3 Comments
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 250 total points
ID: 39639287
You could grant it to the public role.

grant insert on <table> to public;
go

Open in new window

0
 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 250 total points
ID: 39639805
And make sure those logins are mapped to the database where your table is, otherwise you will not be able to access it regardless of the GRANT statement above.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.

770 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