• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 506
  • Last Modified:

How to check all sp permission in sql2000

I would like to know in Sql2000 how do we check what permission has in each sp? I know that this possible via EM, but this require me to check one by one, how about T-sql?
0
motioneye
Asked:
motioneye
1 Solution
 
RiteshShahCommented:
--List all user permissions of all Database objects
USE dbName
sp_helprotect
GO
-- List all user permissions of a table
USE dbName
sp_helprotect 'tableNme'
GO
-- List all user permissions of stored procedure
USE dbName
exec sp_helprotect 'spName'
GO
-- List all user permissions of sp granted by dbo
USE dbName
sp_helprotect 'spName', null,dbo
GO
-- List all Object type user permissions
USE dbName
sp_helprotect null, null,null,'o'
GO
-- List all statement type user permissions
USE dbName
sp_helprotect null, null,null,'s'
GO
0
 
motioneyeAuthor Commented:
sp_helprotect ner to close  to help me, what I'm looking for is any sp or T-sql which able to list me all only sp with permissions status ad other objects such extend procedures,tables will not require
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now