查看帐号授权信息

查看指定帐号的授权信息

select OBJECT_NAME (id), USER_NAME (uid),
case action
when 193 then 'select'
when 195 then 'insert'
when 196 then 'delete'
when 197 then 'update'
when 224 then 'execute'
else null end ,
case protecttype
when 205 then 'GRANT'
when 206 then 'DENY'
else null end ,
columns,
grantor
from sysprotects where uid = USER_ID( 'xxx')