CODEWITHSUNDEEP

sqlsql-serversql-server-2008t-sql

Samoth

Reputation: 460

SQL server - privileges to get metadata of database

What minimum privileges my user needs to get metadata (name of tables, columns, procedures, etc.) from database?

I need to select from:

[database].sys.objects
[database].sys.schemas
[database].sys.extended_properties
[database].sys.sql_modules
[database].information_schema.columns

db_datareader is ok, but I need minimum privileges.

Upvotes: 0

Views: 2792

Answers (1)

Reputation: 2438

In order to let user only query metadata of objects, just give him the VIEW ANY DEFINITION permission, as described here: http://msdn.microsoft.com/en-us/library/ms175808(v=sql.105).aspx

Upvotes: 4

Related Questions