rights for each login

Hi ,
1 - How do i know the rights for each logins ? is there
any command to show it ?
2 - There's a client application linked to the SQL
server , how will i be able to check if it's using the
application role or the role specified inside the SQL
server ?
Appreciate if there's anyone that could help me out
thks & rdgs
Hi
1) Look at sp_helprotect system procedure.
2)sp_helprole
"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:9ec501c4791f$01827350$a401280a@.phx.gbl...
> Hi ,
> 1 - How do i know the rights for each logins ? is there
> any command to show it ?
> 2 - There's a client application linked to the SQL
> server , how will i be able to check if it's using the
> application role or the role specified inside the SQL
> server ?
> Appreciate if there's anyone that could help me out
> thks & rdgs
>
|||Hi Uri ,
thks but can i find out further
i have used exec sp_helprotect null, 'abc' which abc is a
user. however the system returns 'there are no matching
roles on which to report'
in ur opinon , wat could be the cause ?
thks & rdgs
>--Original Message--
>Hi
>1) Look at sp_helprotect system procedure.
>2)sp_helprole
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:9ec501c4791f$01827350$a401280a@.phx.gbl...
there
>
>.
>
|||Hi Uri ,
thks but can i find out further
i have used exec sp_helprotect null, 'abc' which abc is a
user. however the system returns 'there are no matching
roles on which to report'
in ur opinon , wat could be the cause ?
thks & rdgs
>--Original Message--
>Hi
>1) Look at sp_helprotect system procedure.
>2)sp_helprole
>
>"maxzsim" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:9ec501c4791f$01827350$a401280a@.phx.gbl...
there
>
>.
>
|||BOL says
B. List the permissions for a user
This example lists all permissions that user Judy has in the current
database.
EXEC sp_helprotect NULL, 'Judy'
If you get the error (in your case) so the user abc does not exist in the
system"maxzsim" <anonymous@.discussions.microsoft.com> wrote in message
news:a21f01c4793b$87054f40$a501280a@.phx.gbl...[vbcol=seagreen]
> Hi Uri ,
> thks but can i find out further
> i have used exec sp_helprotect null, 'abc' which abc is a
> user. however the system returns 'there are no matching
> roles on which to report'
> in ur opinon , wat could be the cause ?
> thks & rdgs
> message
> there
|||Hi
I have actually looked under the users of that database
before i execute the command. it's ok for another server
but not this one
rdgs
>--Original Message--
>BOL says
>B. List the permissions for a user
>This example lists all permissions that user Judy has in
the current
>database.
>EXEC sp_helprotect NULL, 'Judy'
>If you get the error (in your case) so the user abc does
not exist in the
>system"maxzsim" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:a21f01c4793b$87054f40$a501280a@.phx.gbl...
a[vbcol=seagreen]
in[vbcol=seagreen]
the
>
>.
>