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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2007-01-19 : 03:35:02
|
| Hi,I have added two roles to sql server. One called Officeusers. The other AdminUsersAdded the appropriate logins to these roles. For example; james, john, ahmad to OfficeUsers and Mat, Nick to AdminUsers.How can these roles be now used in a connectionstring? I can use each user login and his relevant password in a connectionstring to connect to sql server but not sure how/where/when the Roles come in to development.i.e. do I need to use the role in the connectionstring? if so then what happens to the password.Not quite clear about all these.Thanks |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-19 : 03:43:03
|
| Roles has nothing to do with the connection string. There are two types of security:1. Authentication2. AuthorizationWhen you provide user name & password in connection string, you are being authenticated by SQL Server as valid user. Roles comes under the category of Authorization. After you login successfully, roles determine what you can do and cannot do inside the database.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2007-01-19 : 03:49:26
|
| Ok, so let's say I create a login called webuser with a password. Then all the webusers can enter the intranet using this login through the system.How do I then use the roles as mentioned before. Is this to do with SQL sysntax to find out if a user is in a role? should I use sql to get the systemuser?Thanks |
|
|
|
|
|
|
Roles security