Can db_datareader query INFORMATION_SCHEMA?
0
votes
1
answer
50
views
Microsoft documentation says about
db_datareader
role that:
>db_datareader
: Members of the db_datareader fixed database role can read all data from all user tables and views. User objects can exist in any schema except sys and INFORMATION_SCHEMA.
The last sentence is confusing for me. I think it means that users whose only role is db_datareader cannot query things inside INFORMATION_SCHEMA, but I made a user with only that role for a database and I successfully ran queries like below on that database:
* FROM INFORMATION_SCHEMA.TABLES
Doesn't this contradict that last sentence? What is the correct interpretation of the last sentence?
Asked by PedroAsking
(3 rep)
Dec 25, 2024, 04:39 PM
Last activity: Dec 25, 2024, 05:01 PM
Last activity: Dec 25, 2024, 05:01 PM