script to find that a login has permissions to which tables & SP's

• connect_ninad

  SSC Enthusiast

  Points: 142

  More actions

  December 19, 2007 at 1:20 am

  #71206

  Dear All,

  Can you give me a script\query wherein I wud be able to

  find whether a login has permissions to which tables & Sp's

  .....and what permissions.

  regards,

  Ninad

• Eshwaran

  SSC Veteran

  Points: 229

  More actions

  December 19, 2007 at 6:11 am

  #761364

  Use the below one which will give the access in the current database.

  sp_helprotect [ [ @name = ] 'object_statement' ]

  [ , [ @username = ] 'security_account' ]

  [ , [ @grantorname = ] 'grantor' ]

  [ , [ @permissionarea = ] 'type' ]