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 |
|
ruan4u
Posting Yak Master
132 Posts |
 Posted - 2004-08-04 : 09:47:33
|
Our app connects to sql only through windows authentication.Now what minimum windows user rights should a dba have.All database objects are also given DBO rights only. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-04 : 12:52:48
|
| A DBA should have sysadmin fixed server role inside SQL Server and local admin privileges on the server.Tara |
 |
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-08-04 : 14:01:26
|
| We are developling a vb-sql app. Is it good to have SQL authentication or windows authentication |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-04 : 14:04:03
|
| Windows authentication is best.Tara |
|
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-08-04 : 18:09:59
|
| Why would you say so.We have bumped into situations where clients have only novel setup. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-04 : 19:19:18
|
| Windows Authentication is more secure and easier to manage. There are times when you unfortunately have to use SQL Authentication. It should only be used when absolutely necessary. You can search www.microsoft.com and www.sqlsecurity.com for more information on why it's more secure. Cisco and Microsoft also publish white papers on secure architecture that you should consider studying.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-04 : 21:18:13
|
| Yes with Novell you wouldn't be able to use Windows authentication. But if you are in a Windows environment, the best security approach is Windows authentication.Tara |
|
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2004-08-06 : 05:40:28
|
| I would say! Im new but I can see how much easier it would be to manage using the windows accounts... Studying hard at SQL server... Man it can do so much, im really looking forward to my design course... and Yukon for that matter :) |
|
|
|
|
|
|
windows authentication