Permissions to syslogins

From: Audrey Lim (robwhitz_at_yahoo.com)
Date: 07/29/03 

Date: Tue, 29 Jul 2003 07:26:13 -0700

I have created a new id 'dba' and attempted to use this id
to query the syslogins. It gave me an error that I do not
have permission to the view.

I opened up 'SELECT' permissions on the view to dba, but
hit the error stating that I do not have permission
to 'password' field.

Is there any special rights needed to access this field?
Basically I'm performing a query to return users with null
password.

Regards,
Audrey

Relevant Pages

  • Re: Object permissions
    ... objQDF.SQL= strSQLAttendance with the error about not having necessary ... implicit 'read and modify' permissions on the query. ... If I set up a new query with this user or their group as the owner, ... Especially when this code should work with only the modify permission ...
    (microsoft.public.access.security)
  • Re: Object permissions
    ... only the owner can set the RWOP property on a query. ... Once I removed that line from the sql, ... you grant modify permission on the qryAttendanceActual query. ...
    (microsoft.public.access.security)
  • Re: Disable control
    ... Joan Wild ... Microsoft Access MVP ... Does it actually say 'query' or does it say the name of some query? ... need to give as a minimum 'Read Data' permission on that query. ...
    (microsoft.public.access.security)
  • msystables? / users saving their own queries?
    ... I want the users of this system to be able to save custom queries based on ... tables that they have permission to and run and save a query. ... MSysObjects -> owner is Engine ...
    (microsoft.public.access.security)
  • Re: Disable control
    ... Joan Wild ... Microsoft Access MVP ... Does it actually say 'query' or does it say the name of some query? ... need to give as a minimum 'Read Data' permission on that query. ...
    (microsoft.public.access.security)