Forum Discussion
SQLDBA201400
Nov 22, 2023Copper Contributor
SQL Object Access Question
I need to grant select access to an account on these: sys.schemas sys.foreign_keys INFORMATION_SCHEMA.VIEWS sp_tables sp_statistics 1) Can this be granted only for a specific database on ...
olafhelper
Nov 27, 2023Bronze Contributor
SQLDBA201400 , by default every user can query those system views, but they return only informations for objects the user has access to.
See for example sys.schemas (Transact-SQL) - SQL Server | Microsoft Learn
=> Permissions => "Public role"