Re: Permissions to syslogins

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

  • Next message: Dan Guzman: "Re: Permissions to syslogins" 
    Date: Tue, 29 Jul 2003 18:35:46 -0700

    Hi,

    The sa is a secured id under key and lock. Therefore I
    have to create a separate id 'dba' to allow me to
    administer the database. In fact, 'dba' has most of the
    roles, but not System Administration, as this will allow
    the id to perform any tasks on the database.

    Is there any other way out for me to query syslogins on
    password that is null?

    Regards,
    Audrey

    >-----Original Message-----
    >If you look at the permissions on syslogins you'll see it
    has column level
    >permissions on it and public is denied select permission
    on the password
    >field. Only sysadmins should have access to this.
    >
    >--
    >HTH
    >
    >Jasper Smith (SQL Server MVP)
    >
    >I support PASS - the definitive, global
    >community for SQL Server professionals -
    >http://www.sqlpass.org
    >
    >"Audrey Lim" <robwhitz@yahoo.com> wrote in message
    >news:0ab801c355dd$5d236540$a501280a@phx.gbl...
    >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
    >
    >
    >.
    >

  • Next message: Dan Guzman: "Re: Permissions to syslogins"

    Relevant Pages

    • Re: Creating index - Error 229 (Permission denied)
      ... You do not have permissions to access sysjobs_view in database msdb and also execute sp_help_category in msdb. ... Your DBA needs to give you the correct permissions to see the schedules, ... I have my development database on a SQL Server 2005 server. ...
      (microsoft.public.sqlserver.fulltext)
    • Re: More security questions
      ... view group permissions, one of the items that can be checked is ... I expect this is to administer user accounts, ... To do that I am using this as the target in the shortcut: ... and then complain that the database doesn't work. ...
      (microsoft.public.access.security)
    • Re: Access 97 Security issue Cant make a MDE
      ... I am the owner of the database, I was signed in with my own user ID which I ... ID I used to initially secure the DB (admin) is the username which ALSO has ... but a non-owner user with the following permissions can usually create ... >> that the user account has Modify Design or Administer permissions for the ...
      (microsoft.public.access.security)
    • Re: Do Table Permissions Override Query permissions?
      ... I administer a database in which the permissions have been "messed up" ... but there are so many user created queries ...
      (microsoft.public.access.security)
    • Do Table Permissions Override Query permissions?
      ... I administer a database in which the permissions have been "messed up" ... but there are so many user created queries ...
      (microsoft.public.access.security)