RE: Programatically find out stored procedures properties
From: Mal .mullerjannie_at_hotmail.com> (.mullerjannie_at_hotmail.com)
Date: 02/01/05
- Next message: Ami Levin: "Re: typo error..."
- Previous message: Louis Davidson: "Re: Cannot reference derived table from a derived table in a subquery?"
- In reply to: dfate: "Programatically find out stored procedures properties"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 1 Feb 2005 09:33:02 -0800
Hi
I'm sure if you asks questions like this you know you way around SQL,
I did some searching in BOL since this is something that could be usefull
and I would in the future maybe use it.
So I came across this
A. List the permissions for a table
This example lists the permissions for the titles table.
EXEC sp_helprotect 'titles'
B. List the permissions for a user
This example lists all permissions that user Judy has in the current database.
EXEC sp_helprotect NULL, 'Judy'
Now there's a lot of other "users info" tables and processes, so I'm sure if
you search BOL you'll find some usefull info. I'll search and see if I can
come up with something, and add it.
HTH
"dfate" wrote:
> Hi all,
> How do I find out what id's have execute permissions on each procedure in a
> database for all procedures using t-sql?
>
> -Thanks! dave
>
>
>
- Next message: Ami Levin: "Re: typo error..."
- Previous message: Louis Davidson: "Re: Cannot reference derived table from a derived table in a subquery?"
- In reply to: dfate: "Programatically find out stored procedures properties"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
