Re: Getting a list of Stored Procedures
From: Craig G (Gambit001_at_hotmail.com)
Date: 06/23/04
- Next message: Keith: "Re: Trigger Error"
- Previous message: Roji. P. Thomas: "Re: Recursive stored procedure ?"
- In reply to: Wayne Snyder: "Re: Getting a list of Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Jun 2004 13:57:00 +0100
Cheers folks!!
"Wayne Snyder" <wayne.nospam.snyder@mariner-usa.com> wrote in message
news:eBXR$fRWEHA.1888@TK2MSFTNGP11.phx.gbl...
> 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: Keith: "Re: Trigger Error"
- Previous message: Roji. P. Thomas: "Re: Recursive stored procedure ?"
- In reply to: Wayne Snyder: "Re: Getting a list of Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
