CODEWITHSUNDEEP
sql-server
FabianTe
FabianTe

Reputation: 649

What permissions are needed to access INFORMATION_SCHEMA?

What permissions are needed to access INFORMATION_SCHEMA in MSSQL?

My test user on a newly created test database has been assigned as database owner so he can do whatever he wants. But I'd like to figure out, what rights a database user needs to have to read information from INFORMATION_SCHEMA

Thanks!

Upvotes: 2

Views: 3071

Answers (1)

DavidG
DavidG

Reputation: 119066

The permissions for each view in INFORMATION_SCHEMA are different, you need to check the individual help for each one.

For example the TABLES view docs state:

Returns one row for each table in the current database for which the current user has permissions.

Upvotes: 2

Related Questions