---
title: "How to grant permission to User on a single table in SQL server?"  
description: "How to grant permission to User on a single table in SQL server?"  
author: "Ashutosh Patel"  
published: 2024-11-13  
updated: 2025-01-03  
canonical: https://www.mindstick.com/forum/161031/how-to-grant-permission-to-user-on-a-single-table-in-sql-server  
category: "mssql server"  
tags: ["mssql server", "sql server", "sql", "SQL Database"]  
reading_time: 1 minute  

---

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

How to [grant permission](https://www.mindstick.com/forum/160922/how-to-create-user-and-grant-permission-in-sql-server) to an [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) [User](https://www.mindstick.com/articles/13001/multi-statement-table-valued-user-defined-function-in-sql-server) on a single [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) to prevent any specific [Action](https://www.mindstick.com/forum/155752/what-is-action-result-with-its-types)?

## Replies

### Reply by Khushi Singh

For a general [permission](https://www.mindstick.com/forum/159434/linux-service-permission-denied-error-adjust-permissions) of a user on SQL Server on a single table, the command that is used is the `GRANT`statement. Here's how:

Syntax:

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

## Example:

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

```plaintext
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.

\


---

Original Source: https://www.mindstick.com/forum/161031/how-to-grant-permission-to-user-on-a-single-table-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.