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 |
|
asuni
Yak Posting Veteran
55 Posts |
 Posted - 2010-05-25 : 06:02:39
|
| Hi All,What is the difference between CREATE LOGIN and CREATE USER.Can we create user for particular database exists in one server.Because i create the user it is working for all databases exists in the server.thanks |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
|
|
asuni
Yak Posting Veteran
55 Posts |
Posted - 2010-05-25 : 08:29:26
|
| OK, THANKSCan we create user for particular database exists in one server.Because i create the user it is working for all databases exists in the server.It is creating prob to me. |
 |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-05-25 : 08:59:51
|
| What i understand is that you want to create a user and the user should have access to only one database.If my understanding is correct then you can do the same by giving neccassary permission only for the particular database.If my understanding is wrong then i request you to give more details on your requirement.Regards,BohraI am here to learn from Masters and help new bees in learning. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-05-25 : 09:13:09
|
| In the new login screen set the Default Database to the database you want the user to access for and in User Mapping in the same screen map the database to the user you have created.PBUH |
|
|
|
|
|
|
Create User