Checking procedure privilege by T-SQL

• Del Piero

  SSCrazy

  Points: 2265

  More actions

  December 4, 2005 at 6:41 am

  #188625

  Hi all,

         When we want to check the access privilege of a particular table, we can use "exec sp_table_privileges <table_name>" in T-SQL. Is there a similar built-in stored procedure to check the execute privilege of a stored procedure, from T-SQL?

  Thank you,

  delpiero

   

• Carl Federl

  One Orange Chip

  Points: 25384

  More actions

  December 4, 2005 at 9:32 am

  #607594

  System procedure sp_MSobjectprivs can be used with all types of objects.

  -- Table

  exec Northwind.dbo.sp_MSobjectprivs @objname = 'dbo.Customers'

  -- View

  exec Northwind.dbo.sp_MSobjectprivs @objname = 'dbo.Alphabetical list of products'

  -- Stored Procedure

  exec Northwind.dbo.sp_MSobjectprivs @objname = 'dbo.Sales by Year'

  SQL = Scarcely Qualifies as a Language

• Del Piero

  SSCrazy

  Points: 2265

  More actions

  December 4, 2005 at 10:06 am

  #607595

  Thanks a lot Carl.

  delpiero