Permission

Hi,
is there a way to know every permission that a specific user has in the SQl
server using a Sql line '
I know individually ! But I would like a process that will look in all datab
ases all roles, and so on !
Any help I'll apreciate !
Thank'sHi,
Have a look into the procedure sp_helprotect in books online.
Thanks
Hari
MCDBA
"Carrasco" <Carrasco@.discussions.microsoft.com> wrote in message
news:81C7D2F3-624D-4331-A257-5792D75CD82F@.microsoft.com...
> Hi,
> is there a way to know every permission that a specific user has in the
SQl server using a Sql line '
> I know individually ! But I would like a process that will look in all
databases all roles, and so on !
> Any help I'll apreciate !
> Thank's
>