Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Query sys syslogins

69>  SELECT name, hasaccess, isntname, isntgroup, isntuser, sysadmin 70> FROM sys.syslogins 71> WHERE LEFT(name, 4) <> '##MS' 72> GO name                                                                                                                             hasaccess   isntname    isntgroup   isntuser    sysadmin -------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ----------- ----------- sa                                                                                                                                         1           0           0           0           1 BUILTIN\Administrators                                                                                                                     1           1           1           0           1 NT AUTHORITY\SYSTEM                                                                                                                        1           1           0           1           1 J\SQLServer2005MSSQLUser$J$SQLEXPRESS                                                                                                      1           1           1           0           1 BUILTIN\Users                                                                                                                              1           1           1           0           0 (5 rows affected) 1> 2> IF EXISTS(SELECT * FROM sys.syslogins 3>     WHERE name = N'computername\winlogin1') 4>     DROP LOGIN [computername\winlogin1] 5> GO 1> 2> CREATE LOGIN [computername\winlogin1] FROM WINDOWS 3> GO Msg 15401, Level 16, State 1, Server J\SQLEXPRESS, Line 2 Windows NT user or group 'computername\winlogin1' not found. Check the name again. 1> 2> SELECT name, hasaccess, isntname, isntgroup, isntuser, sysadmin 3> FROM sys.syslogins 4> WHERE LEFT(name, 4) <> '##MS' 5> GO name                                                                                                                             hasaccess   isntname    isntgroup   isntuser    sysadmin -------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ----------- ----------- sa                                                                                                                                         1           0           0           0           1 BUILTIN\Administrators                                                                                                                     1           1           1           0           1 NT AUTHORITY\SYSTEM                                                                                                                        1           1           0           1           1 J\SQLServer2005MSSQLUser$J$SQLEXPRESS                                                                                                      1           1           1           0           1 BUILTIN\Users                                                                                                                              1           1           1           0           0 (5 rows affected) 1>