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 |
|
Davids_Maguire
Starting Member
14 Posts |
 Posted - 2007-01-14 : 17:20:51
|
| hi all ,any decribtion about users and logins and differncs between them ??and any example for real use in real life ??i use logins user name and passwords in the connection string from c# but how users can make difference with that ??thnks so much for your help |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-15 : 03:56:17
|
| A user is a database entity and a login is a server entity.You create a login and connect to that. This is mapped to users in databases which give you access to those databases with the permissions assigned to the user.Of course if a login is in the sysadmin role it gains dbo access to all databases and any mapped users are ignored.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Davids_Maguire
Starting Member
14 Posts |
Posted - 2007-01-15 : 05:20:26
|
| thnks nr but i really need more about the last sentence "Of course if a login is in the sysadmin role it gains dbo access to all databases and any mapped users are ignored."what is role ?? does it give a permission of some kind ??and dbo is user and created by default for each database ?? dbo has all permissions?thnks again |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-15 : 05:51:53
|
| You need to read about SQL Server security architecture in Books online. If you don't have it, you can download it from Microsoft site or take a look here to view documentation online:[url]http://msdn2.microsoft.com/en-us/library/aa257103(SQL.80).aspx[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-15 : 06:10:33
|
| dbo is database owner and is a role in each database - allows a user to do anything in the database.sysadmin is a fixed server role - anyone a member of it can do anything on the server.There are a number of server roles all bestowing different permissions.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Users And Logins