RE: help! report users permission on a SQL 2000 server
From: Fany Vargas [MSFT] (fanyv_at_online.microsoft.com)
Date: 11/28/04
- Previous message: Dan Guzman: "Re: Execute UDF/extended stored procedure only through view?"
- In reply to: Wen Ou: "RE: help! report users permission on a SQL 2000 server"
- Next in thread: Fany Vargas [MSFT]: "RE: help! report users permission on a SQL 2000 server"
- Reply: Fany Vargas [MSFT]: "RE: help! report users permission on a SQL 2000 server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 28 Nov 2004 03:10:54 GMT
Look into the PERMISSIONS function. It returns a value containing a bitmap
that indicates the statement, object, or column permissions for the current
user. So you can run something like:
SELECT PERMISSIONS(OBJECT_ID('nameofobject'))
For details on how to decipher the bitmap you will need to reference BOL
article: "PERMISSIONS"
(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\ts
qlref.chm::/ts_pa-pz_6f78.htm) - in BOL, select Go->Url...
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
- Previous message: Dan Guzman: "Re: Execute UDF/extended stored procedure only through view?"
- In reply to: Wen Ou: "RE: help! report users permission on a SQL 2000 server"
- Next in thread: Fany Vargas [MSFT]: "RE: help! report users permission on a SQL 2000 server"
- Reply: Fany Vargas [MSFT]: "RE: help! report users permission on a SQL 2000 server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
