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 |
|
Haiasc
Starting Member
2 Posts |
 Posted - 2006-11-05 : 13:00:38
|
| Dear mems,I have a problem, and i don't khow how to resolve, pls help me:My server is Windows XP (not domain), I work with SQL Server 2005, installed on my server, I configurate my SQL SERVER connection is "Windows Authentication mode",I add user "MyComputer\guest" to MyServer\Secutity\Logins to accept connections from local networkI have many databases: Db1, Db2, Db3...But, I don't know to configurate my SQL Server to achive these:1) My clients using "SQL Server Managment Studio" connect to Databases Db2, Db3... on my Server, they can expand, modify, add new all Tables, Sp, functions of Db2, Db3.2) My clients are not allow to access Db1.2) My clients can add new Databases Db4, Db5, Db6... in the future and they have full permission on every Database which they create without my interfere.Best regard, |
|
|
EugeneZ
Starting Member
26 Posts |
Posted - 2006-11-05 : 13:28:40
|
| There is not need to give "MyComputer\guest" such permission - normaly it is disabled....Create sql server login and grant the login all permissions that you need to grantAdd the login to dbcreator - sql server rolemore:SQL Server 2005 Books Online Managing Logins and Users How-to Topics http://msdn2.microsoft.com/en-us/library/aa337552.aspx |
 |
|
|
Haiasc
Starting Member
2 Posts |
Posted - 2006-11-05 : 22:45:14
|
| Dear EugeneZ,I configurate my SQL Server connection is "Windows Authentication mode", so as your rely I must create sql server login and grant the login all permissions..., i expect to use and permission at built-in users from windows like guest..., Can u direct me this,Best regard,Haiasc |
|
|
|
|
|
|
|
|
Security in SQL SERVER 2005???