Re: Getting a list of Stored Procedures
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 06/23/04
- Next message: Raj Kumar: "Re: Converting an Oracle Trigger Script into SQL Server"
- Previous message: Wayne Snyder: "Re: UDT has default value but column hasn't, why?"
- In reply to: Craig G: "Getting a list of Stored Procedures"
- Next in thread: Craig G: "Re: Getting a list of Stored Procedures"
- Reply: Craig G: "Re: Getting a list of Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Jun 2004 07:45:13 -0400
Take a look at sp_helprotect. It is doc's in books on line and gives you the
permissions associated with an object.... If you can not use the sp
directly, then check out the code inside and use it to create your own sp.
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Craig G" <Gambit001@hotmail.com> wrote in message news:eJ2y7uQWEHA.2996@TK2MSFTNGP12.phx.gbl... > where/how can i get a list of stored procedures for a certain database and > details on which users have excute privlege on them > > i have been given a task of designing something similar along the lines of > what SQL2000 already does, something similar to when you select manage > persmissions in Enterprise manager and it brings up the little dialog where > you can tick or x privileges for users. > > Cheers, > Craig > >
- Next message: Raj Kumar: "Re: Converting an Oracle Trigger Script into SQL Server"
- Previous message: Wayne Snyder: "Re: UDT has default value but column hasn't, why?"
- In reply to: Craig G: "Getting a list of Stored Procedures"
- Next in thread: Craig G: "Re: Getting a list of Stored Procedures"
- Reply: Craig G: "Re: Getting a list of Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
