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-02-27 : 05:14:35
|
| dear all, First i'm using MS Sql Express and Management Studio.I have to create a new login that have the ability to read only from a specific database.using the management studion i created a new login and in the user mapping tab i tried to map this login to a user that have a read only permission but i couldn't ."it gives an error"I really appreciate your help if any one can give me a step by step way to do this.Davids Maguire |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-02-27 : 05:27:26
|
| Which error did you get when adding an user with DATA_READER permissions?Peter LarssonHelsingborg, Sweden |
 |
|
|
Davids_Maguire
Starting Member
14 Posts |
Posted - 2007-02-28 : 08:07:42
|
| ok now , i used the management studio and created a new login and in the user mapping tab i clicked the check box associated to my database and the management studio created a new user for the database with the same name as the login.i tried to make this user have the ability to read only from the database but i couldn't .i make the defult schema data reader and then deny datawritter.(i don't know what is schema is about but i tried)??then i tried to change the role membership to be datareader and deny datawriter but still the same.My application still have the ability to update records and insert data in the database when i use this login ??what is the problem and how I can accomplish what i need ?? |
|
|
|
|
|
|
New Login that can "Read Only"