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 |
|
jogin malathi
Posting Yak Master
117 Posts |
 Posted - 2007-05-01 : 02:42:46
|
| Hi All i WANT to create users for database or sever in SQL SERVER 2005HOW CAN I GOThanks in AdvanceMalathi Rao |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-05-01 : 02:55:26
|
Easier way is use the SQL Server Management Studio - Security - Logins - User Mapping
KH |
 |
|
|
jogin malathi
Posting Yak Master
117 Posts |
Posted - 2007-05-01 : 02:57:49
|
quote:
Originally posted by khtan
Easier way is use the SQL Server Management Studio - Security - Logins - User Mapping
KH
ya iam using the same window but their i can find dbreader and all those rolesMalathi Rao |
|
|
|
jogin malathi
Posting Yak Master
117 Posts |
Posted - 2007-05-01 : 03:07:41
|
quote:
Originally posted by khtan
Easier way is use the SQL Server Management Studio - Security - Logins - User Mapping
KH
What is the difference betwen export data and import data in sql serveriam doing usine SQL Server Management Studio but unable to understand the differenceMalathi Rao |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-05-01 : 03:09:05
|
I don't think there is such role in SQL 2005
KH |
|
|
|
jogin malathi
Posting Yak Master
117 Posts |
Posted - 2007-05-01 : 03:14:22
|
quote:
Originally posted by khtan
I don't think there is such role in SQL 2005
KH
okI want to security to My database as one can only view my databasemodifications are not allowed how can i do this.Malathi Rao |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-01 : 10:05:34
|
| Put user in db_datareader role only. |
|
|
|
|
|
|
Creating Users