sql server2005如何查询一个登录名的权限。

使用sa登录sql server2005，怎样查询一个登录名有哪些读写权限以及能够操作哪些表？

sp_helprotect

-- 查询当前数据库用户账户的权限
select object_name(id) obj,
(case [action] when 26 then 'REFERENCES'
 when 178 then 'CREATE FUNCTION'
 when 193 then 'SELECT'
 when 195 then 'INSERT'
 when 196 then 'DELETE'
 when 197 then 'UPDATE'
 when 198 then 'CREATE TABLE'
 when 203 then 'CREATE DATABASE'
 when 207 then 'CREATE VIEW'
 when 222 then 'CREATE PROCEDURE'
 when 224 then 'EXECUTE'
 when 228 then 'BACKUP DATABASE'
 when 233 then 'CREATE DEFAULT'
 when 235 then 'BACKUP LOG'
 when 236 then 'CREATE RULE' end) perm
from sysprotects where [uid]=user_id()

SQL code

--sql 2000
-- 查询当前数据库用户账户的权限
select object_name(id) obj,
(case [action] when 26 then 'REFERENCES'
 when 178 then 'CREATE FUNCTION'
 when 193 then 'SELECT'
 when 195 then 'INSERT'
 when 196 then 'DELETE'
 when 197 then 'UPDATE'
 when 198 then 'CREATE TABLE'
 when 203 then 'CREATE DATABASE'
 when 207 then 'CREATE VIEW'
 when 222 then 'CREATE PROCEDURE'
 when 224 then 'EXECUTE'
 when 228 then 'BACKUP DATABASE'
 when 233 then 'CREATE DEFAULT'
 when 235 then 'BACKUP LOG'
 when 236 then 'CREATE RULE' end) perm
from sysprotects where [uid]=user_id()

--sql 2005
EXECUTE AS LOGIN = 'sa';  
SELECT * FROM fn_my_permissions(NULL, 'DATABASE');  
REVERT;

+1