List of objects which are accessible to a particulat DB account

• Rookee DBA

  SSCrazy

  Points: 2188

  More actions

  February 19, 2009 at 4:03 pm

  #97116

  I have a DB on which we are created some accounts for logins. I need to know the list of tables, procedure and functions which are accessible to a particular login account. Can somone help me some sql query

  siddarth

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  February 20, 2009 at 6:48 am

  #947455

  Here are a couple of scripts in the SSC script library that either do what you want or will point you in the right direction:

  http://www.sqlservercentral.com/scripts/64793/

  http://www.sqlservercentral.com/scripts/Permissions/64309/

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Rookee DBA

  SSCrazy

  Points: 2188

  More actions

  February 23, 2009 at 3:10 am

  #948484

  thanks alot for the help 🙂

  Cheers

  Siddarth

• Rookee DBA

  SSCrazy

  Points: 2188

  More actions

  February 24, 2009 at 5:37 pm

  #949723

  the issue is sorted for me 🙂

  once again, thanks