Usuarios del servidor sql 2000, ¿como saberlos?

[iislas]

El password, esta encryptado y nunca podras verlo, ok???

Para ver tus usuarios y a que tienen derecho:


SELECT b.name 'Object Name', c.name 'User/Group/Role Name',
CASE action
WHEN 26 THEN 'REFERENCES'
WHEN 193 THEN 'SELECT'
WHEN 195 THEN 'INSERT'
WHEN 196 THEN 'DELETE'
WHEN 197 THEN 'UPDATE'
WHEN 224 THEN 'EXECUTE'
WHEN 228 THEN 'BACKUP DATABASE'
END 'Permission',
CASE protecttype
WHEN 204 THEN 'GRANT_W_GRANT'
WHEN 205 THEN 'GRANT'
WHEN 206 THEN 'REVOKE'
END 'Grant/Revoke', columns 'Column Permission Code', d.name 'Grantor Name'
FROM sysprotects a, sysobjects b, sysusers c, sysusers d
WHERE a.id = b.id AND c.uid = a.uid AND grantor = d.uid ORDER BY b.name