Login Permissions.....

I have a login user Id which is listed in Security->Login node.
How to list the permissions this user Id has?
I know I can get this info from SP_HELPROTECT. Having trouble in writing the
exact syntax to execute the same. What is the exact syntax to list the
permissions.
SQL 2K.
Thank you,
Allen
Hi,
sp_helplogins <loginname>
This gives you the server roles assigned to that login as well as rights to
variros databases
To look into the object level prev. for a particular database.
EXEC sp_helprotect NULL, 'User_name'
Thanks
Hari
SQL Server MVP
"AllenHubatka" <AllenHubtka_67@.hotmail.com> wrote in message
news:O$k%232iNqFHA.616@.TK2MSFTNGP15.phx.gbl...
>I have a login user Id which is listed in Security->Login node.
> How to list the permissions this user Id has?
> I know I can get this info from SP_HELPROTECT. Having trouble in writing
> the
> exact syntax to execute the same. What is the exact syntax to list the
> permissions.
> SQL 2K.
> Thank you,
> Allen
>
>