Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kirandbasql
Starting Member
4 Posts |
 Posted - 2009-03-02 : 22:57:00
|
| what is the difference between login and user. |
|
|
subhash chandra
Starting Member
40 Posts |
Posted - 2009-03-03 : 01:57:11
|
| Login is entity for server level while User is entity for database level. To get Login's list execute the query:SELECT * FROM sys.server_principals and to get Users list in a database execute hte query:SELECT * FROM sys.database_principals |
 |
|
|
|
|
|
login,user