SQL Object Access Question

• sqldba20

  Ten Centuries

  Points: 1308

  More actions

  November 22, 2023 at 3:50 pm

  #4332527

  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 the Instance or is it at server level?

  2) Does grant View Definition access grant access to all of the above?

  Thanks!

• Johan Bijnens

  SSC Guru

  Points: 135379

  More actions

  November 23, 2023 at 1:22 pm

  #4333090

  it depends:

  Have a look at GRANT

  and GRANT Server Permissions

  GRANT view definition ....
  
  vs
  
  
  GRANT view ANY definition ...

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me