How to grant permission to User on a single table in SQL server?

Question

Khushi Singh · Answer

For a general permission of a user on SQL Server on a single table, the command that is used is theGRANTstatement. Here's how:

Syntax:

GRANT [PERMISSION] ON [TABLE_NAME] TO [USER];

Example:

If you want to give a user named John SELECT permission on a table called Employees:

GRANT SELECT ON Employees TO John;

Common Permissions:
SELECT – To read data.
INSERT – To add data.
UPDATE – To modify data.
DELETE – To remove data.
Insert PERMISSION by the permission that you would like to allow in the function.

That’s it! After the last operation, the user has the necessary access to the table specified in the command.

forum

How to grant permission to User on a single table in SQL server?

Can you answer this question?

1 Answers