---
title: "Difference between GRANT and WITH GRANT in SQL Server 2008 R2"  
description: "This blog provides an overview of the difference between GRANT and WITH GRANT using SQL Server 2008 R2.GRANT and WITH GRANT:    The difference between"  
author: "Vijay Shukla"  
published: 2013-04-08  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/481/difference-between-grant-and-with-grant-in-sql-server-2008-r2  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Difference between GRANT and WITH GRANT in SQL Server 2008 R2

This [blog](https://www.mindstick.com/articles/12705/myths-and-misconception-about-blog) provides an [overview](https://www.mindstick.com/blog/272/an-overview-of-asp-dot-net-mvc3) of the [difference](https://www.mindstick.com/articles/157114/good-news-or-bad-news-and-the-difference-is) between [GRANT](https://answers.mindstick.com/qa/41775/what-did-prominent-progressive-madison-grant-argue-in-his-book-the-passing-of-the-great-race) and WITH GRANT using [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) 2008 R2.

GRANT and WITH GRANT:

The difference between GRANT and WITH GRANT [options](https://www.mindstick.com/articles/12789/best-options-for-a-home-based-business) is very easy. For the GRANT, the [username](https://www.mindstick.com/forum/12798/there-is-no-viewdata-item-of-type-ienumerable-selectlistitem-that-has-the-key-username) can’t GRANT the same [permission](https://www.mindstick.com/forum/159434/linux-service-permission-denied-error-adjust-permissions) to other users. On the other hand, in the case OF WITH GRANT, the UserId will be able to give the permission after receiving requests from other users.

##### Syntax for GRANT and WITH GRANT:

```
GRANT:

USE model;

GRANT VIEW ANY DATABASE TO UserId;

GO

WITH GRANT:

USE model;

GRANT VIEW ANY DATABASE TO UserId WITH GRANT OPTION;

GO
```

---

Original Source: https://www.mindstick.com/blog/481/difference-between-grant-and-with-grant-in-sql-server-2008-r2

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