Query help requested for Login information 
Author Message
 Query help requested for Login information

I have the following query:

use <database>
go
select master..syslogins.name as login_name,
                sysusers.name as user_name
from master..syslogins inner join sysusers
             on master..syslogins.sid = sysusers.sid
order by 1

                /*  use suid above for SQL 7       */
                /*  use sid  above for SQL 2000    */

which produces a list of logins and their associated user names for
the specified database.

I would like to add a column which would tell if the login is a
"standard" login, or a "windows NT" login, or a "windows group" login.

It seems I recall some properties like "isnt", etc., but don't
remember how to get to them.

Help would be appreciated!!

TIA  solart



Tue, 15 Mar 2005 04:52:40 GMT
 Query help requested for Login information

Quote:

> I have the following query:

> use <database>
> go
> select master..syslogins.name as login_name,
> It seems I recall some properties like "isnt", etc., but don't
> remember how to get to them.

Solart,
/me does impression of Glinda the Good Witch

The answer was inside your database all along!  Just click your keys
together and type: "select * from master..syslogins" and look at
isntname, isntuser and isntgroup



Sat, 19 Mar 2005 02:08:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. help,help,help,help,help,help,help,help,help,help,help,help,help,

2. Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,

3. query:HELP! HELP HELP HELP HELP

4. SQL To ORACLE Help Help Help Help Help

5. Help: Help: Help SQL Server Login Dialog appears!!!!!!!

6. HELP HELP HELP HELP!

7. HELP HELP HELP HELP

8. Login data information request.

9. Query help request

10. Query Help Requested

11. Query Help Request


 
Powered by phpBB® Forum Software