Grant IMPERSONATE SQL Server can be used easily with a little help from our experts. 

At Bobcares, we offer solutions for every query, big and small, as a part of our SQL Server Support Services.

Let’s take a look at how our SQL Server Support Team is ready to help customers with the Grant IMPERSONATE SQL Server command.

How to use Grant IMPERSONATE SQL Server command

The impersonate permission is responsible for adding permission of a specific user to another user. Furthermore, one user can impersonate the permissions of one or more users concurrently. Moreover, we can grant, revoke, or deny the IMPERSONATE SQL Server command.

Interestingly, user impersonation allows a user to perform tasks of another user with permission while retaining the original permissions of the user currently doing the task.

Did you know that SQL Server offers us a special permission called Impersonate? In fact, we can grant, deny or revoke this permission just like other permissions.

Today, our SQL Server experts are going to demonstrate how to grant the IMPERSONATE SQL Server permission to a user:

GRANT IMPERSONATE ON USER::JohnDoe TO MaryJane;  
GO;

In the above example, the user MaryJane impersonates JohnDoe’s permissions.

Alternatively, we can also revoke the Impersonate permission with the following statement:

REVOKE IMPERSONATE ON USER::JohnDoe TO MaryJane;  
GO;

As seen above, the Impersonate permission granted to MaryJane from JohnDoe has been revoked.

Moreover, we should not mistake the IMPERSONATE SQL Server command for the Execute As statement. Let’s take a look at some of the differences between the two:

• The Execute As statement is responsible for switching permission from one user to another until a revert statement or another Execute As statement comes into effect.
• The Impersonate permission allows one user to concurrently impersonate one or more users at the same time.

Now that you have got the hang of the Impersonate statement. Try it out and let us know how it went in the comments.

[Need assistance with a different issue? We are available 24/7.]

Conclusion

In a nutshell, our skilled SQL Server Support Engineers at Bobcares took us through the IMPERSONATE SQL Server command.