Forum Discussion

SQLDBA201400's avatar
SQLDBA201400
Copper Contributor
Nov 22, 2023

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 ...
LainRobertson's avatar
LainRobertson
Silver Contributor
Nov 23, 2023

SQLDBA201400 

 

Hi.

 

  1. Excluding sp_statistics, the remainder can be granted at the database level. That said, sp_statistics can only return information for underlying objects that the user has access to, which of course are objects in the database, meaning database grants are still the control plane;
  2. No, it does not.

 

Cheers,

Lain

Resources