CODEWITHSUNDEEP
sqlsql-serversql-insertsql-grant
Vaseem Akram
Vaseem Akram

Reputation: 69

The INSERT permission was denied on the object 'tablename', database 'database_Name', schema 'SampleSchema'. in SQL Server

I was able to insert the data into the table, now suddenly I got this error where the identity element is being updated with a large negative wrong value and the insert operation is restricted.

Could someone let me know what the problem is?

Upvotes: 1

Views: 15197

Answers (2)

Mukesh Arora
Mukesh Arora

Reputation: 1813

you are getting this error because the user is trying to insert data in SQL server does not have insert permission on the table. You can give permission insert permission using

GRANT Insert ON yourschemaname.yourtablename TO yourusername;  
GO

https://learn.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql?view=sql-server-2017

Upvotes: 6

chunying11
chunying11

Reputation: 7

You'll need to do this (presumably) in SQL-Server (SSMS).

Right-click the table in SQL-Server and give INSERT permissions to the user:

Right Click the table Properties Permissions (if necessary) add the user or role click on the user/role permission insert, put a check-mark in the 'grant' box.

Upvotes: 0

Related Questions