Specific User Permissions
From: Jose Molina (jmolina4@cox.net)
Date: 03/30/03
- Next message: Dorothy B. Thomas: "Solitare Game"
- Previous message: Jose Molina: "MDF file"
- In reply to: Craig Cohen: "Specific User Permissions"
- Next in thread: BP Margolin: "Re: Specific User Permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Jose Molina" <jmolina4@cox.net> Date: Sat, 29 Mar 2003 23:41:38 -0800
Hi Craig,
One way is to use sp_helprotect with the specific object
(in this case a table) and the user name included as
parameters to get what you are looking for. For example,
you wish to get all the permissions on the Product table
for a user, Mary:
1) Make sure that you are connected to the Northwind
database in Query Analyzer
2) Enter the following comand:
sp_helprotect 'Product','Mary'
-Jose
>-----Original Message-----
>Is there a query or stored procedure to run that will
return the table
>permissions for a specific table for a specific user? I
know that SQL Server
>can figure out the users rights by looking at the
individual permissions and
>roles assigned to the user.
>
>
>.
>
- Next message: Dorothy B. Thomas: "Solitare Game"
- Previous message: Jose Molina: "MDF file"
- In reply to: Craig Cohen: "Specific User Permissions"
- Next in thread: BP Margolin: "Re: Specific User Permissions"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
