| Author |
Topic |
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
 Posted - 2010-10-12 : 04:14:46
|
| Hi... I need to create a new user for login into sql server for accessing databases.. How to create a new user in sql server 2005..Thanks in advance... |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-12 : 04:17:20
|
| Using TSQL or SSMS ?PBUH |
 |
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-12 : 04:54:38
|
quote:
Originally posted by Sachin.Nand
Using TSQL or SSMS ?PBUH
Thanks for reply ..I want to create using ssms |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-12 : 05:30:47
|
| Goto SSMS>>Security>>Login>>Right click Login>>New Login.Specify the username & password & the appropriate server roles.PBUH |
|
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-12 : 05:54:57
|
| Thanks..I created a new user to login ... And also i need to create permission to access a database by using the created login name..Sorry for poor english.. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-12 : 05:59:15
|
| Goto Login name you created under Security>>Login>>Right click the user you created>>Properties.In the properties tab you can see User Mapping.Select the necessary databases & database roles for that user.PBUH |
|
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-12 : 06:39:36
|
| Thank you Sachin for your kindly reply..I tried to create a new user and got successed. By using the created login name i loggid in and created a new database ... By using the sa account i can made changes in the created DB .Is there any way to avoid it ..If any possibilities to fix it can you share with me.. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-12 : 08:07:44
|
| Because sa belongs to a serveradmin role & has rights to do anything on the server.PBUH |
|
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-12 : 08:37:59
|
| Is there any way to stop this ..Because my database is in my friend's dedicated server..So i need protect it from viewing and editing my database without my permission..Is there any possibilities...?? |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-12 : 09:04:17
|
| No.For sa I doubt you can change the permissions.PBUH |
|
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-12 : 10:04:23
|
| Ok ..Is there any possibilities to stop writing or adding any datas using sa account for the user created DB... |
|
|
|
jess1984
Starting Member
14 Posts |
Posted - 2010-10-12 : 10:07:30
|
| Its very simple to create new user..... go to msdn site....its very easy man.........jess1984 |
|
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-12 : 10:18:28
|
| Tnx for your reply... |
|
|
|
|
Create user in sql server 2005