Re: Permissions to syslogins

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

Date: Tue, 29 Jul 2003 22:18:06 -0700

Actually I do need the password field, as I want to find
out whether there are any user who do not assign any
password to himself.

My query is such 'select name from syslogins where
password is null'.

Or is there an alternative way I can find out whether the
password field is null?

>-----Original Message-----
>If you don't need the password column, you can specify a
column list
>(omitting password).
>
>--
>Hope this helps.
>
>Dan Guzman
>SQL Server MVP
>
>-----------------------
>SQL FAQ links (courtesy Neil Pike):
>
>http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
>http://www.sqlserverfaq.com
>http://www.mssqlserver.com/faq
>-----------------------
>
>"Audrey Lim" <robwhitz@yahoo.com> wrote in message
>news:083001c3563a$e6312c20$a101280a@phx.gbl...
>> 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
>> >
>> >
>> >.
>> >
>
>
>.
>

Relevant Pages

  • Storing passwords in database
    ... I am using SQL Server as the database for my ASP.NET app. ... I have a users table with a password field. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Storing passwords in database
    ... I am using SQL Server as the database for my ASP.NET app. ... I have a users table with a password field. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Password field
    ... the solution while browsing all the posts while waiting for reply. ... > I am doing a small project which required me to use database driven pages. ... > the password field of that table. ... Prev by Date: ...
    (microsoft.public.access.security)
  • Password field
    ... I am doing a small project which required me to use database driven pages. ... am using access as the database format and I have several tables in the ... the password field of that table. ... Prev by Date: ...
    (microsoft.public.access.security)