Monday , September 25 2023

How To List Object Level Permissions in SQL Server

Sometimes we may need to list object level permissions. I will share a script that list object level permissions in SQL Server in this article. We may want to see which user has which privileges in a particular database, which user has permission in which tables, and which object (stored procedure, view, table) except for instance-based, database-based authorizations in some cases.

List Object Level Permissions in SQL Server

In such cases, you can learn by using the following t-sql statement.


About Faruk Erdem

Leave a Reply

Your email address will not be published. Required fields are marked *