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 |
|
kishore chittam
Starting Member
10 Posts |
 Posted - 2007-11-22 : 13:46:31
|
| We are trying to setup a role based security access within our client software so that users have read only access to the database. Right now we are not able to connect to the database. This is a blocking issue for us on the project right now Please let us know how to proceed now ?Thanks in advanceKishore |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-22 : 16:24:39
|
| What do you mean 'setup a role based security access within our client software'? How does the app connect to sql server? Looked at application role in sql server? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-23 : 22:07:29
|
| Kishore,What error are you getting? Why not just use the db_datareader database role?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2007-11-25 : 22:46:42
|
| Hi Kizer,Thanks for your reply . Actually we have problem with adding the rights to active directory group.I will update you once it is doneThanks,Kishore |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-25 : 22:51:03
|
| Can't add ads group as sql login? Is it in same domain with sql server? |
|
|
|
|
|
|
DB Connectivity