查看指定帐号的授权信息

1 select OBJECT_NAME (id), USER_NAME (uid), 2 case action 3 when 193 then 'select' 4 when 195 then 'insert' 5 when 196 then 'delete' 6 when 197 then 'update' 7 when 224 then 'execute' 8 else null end , 9 case protecttype10 when 205 then 'GRANT'11 when 206 then 'DENY'12 else null end ,13 columns,14 grantor15 from sysprotects where uid = USER_ID( 'xxx')