Re: rights for each login

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Uri Dimant (urid_at_iscar.co.il)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 12:34:07 +0200

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...
> 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
> >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
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: rights for each login
    ... >BOL says ... List the permissions for a user ... >This example lists all permissions that user Judy has in ...
    (microsoft.public.sqlserver.server)
  • Re: all permissions for a particular login
    ... This example lists all permissions that user Judy ... EXEC sp_helprotect NULL, 'Judy' ... SET @objectid = object_id ...
    (microsoft.public.sqlserver.security)
  • Reg. Directory listing program
    ... I am new to this mailing list and I am very new to PERL. ... I wrote a code that lists files in a directory with the permissions. ... Directory listing program ...
    (perl.beginners)
  • Re: Different Access Permission Levels on Sharepoint CompanyWeb?
    ... > WSS provides the ability to control permissions on a per-list basis, ... > users, to groups of users, or to a site group. ... > have access to all lists and document libraries on that Web site. ...
    (microsoft.public.windows.server.sbs)
  • Re: Deleting shortcuts when they are for a C: program
    ... And we only have a name as a parameter so it should say Not Found or the permissions. ... > Displays or modifies access control lists of files ... CI - Container Inherit. ...
    (microsoft.public.windowsxp.general)