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]
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.
GRANT INSERT ON [dbo].[MyTable] TO BillyBob
Or something vaguely similar...
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With