Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Grant user insert permission after create table command

What is the T-SQL syntax for granting a specific user only insert permission after a create table command?

Here is my CREATE TABLE script:

CREATE TABLE [dbo].[MyTable] (
    [MyColumn1] [uniqueidentifier] NOT NULL,
    [MyColumn2] [char] (1) NULL
) ON [PRIMARY]
like image 617
Michael Kniskern Avatar asked May 11 '09 21:05

Michael Kniskern


People also ask

How do I grant insert privileges to a user in SQL Server?

Login to SQL Server Management Studio. In Object Explorer on the left pane, expand the Databases folder and select the concerned database and navigate to the by expanding Security and Users folders. Right-click the User to which you want to GRANT or REVOKE the permissions.


1 Answers

GRANT INSERT ON [dbo].[MyTable] TO BillyBob

Or something vaguely similar...

like image 193
Adrien Avatar answered Nov 03 '22 22:11

Adrien