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 |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2006-03-02 : 09:37:45
|
| HiDo a web admin also needs complete access to the databases just as sql admin. Does any of the deployment process needs sql admin previlages. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-02 : 09:47:40
|
| nope, you only need to create the dsn and allow the application to provide the credentialsalso make sure that the firewall is open between the web and db server if in different segments--------------------keeping it simple... |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-03-02 : 09:48:37
|
no not really.a web admin must ensure the proper working of iis.network admin ensures the db is accessible from web server.dba ensures anthing db related.ideally these are 3 persons. usualy it's 1.  Go with the flow & have fun! Else fight the flow  |
|
|
|
supersql
Yak Posting Veteran
99 Posts |
Posted - 2006-03-02 : 10:06:54
|
| If there are multiple persons with DBA role, is there any way audit their jobs, i mean if one of them mess up something with DB, how can i find that who has done that. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-03-02 : 10:53:02
|
| well you need one top DBA who's the boss. he must be trustworthy.he can them monitor all other junior DBA's and give them proper sql server roles.of course if you're really paranioid you can always have a computer in a dark and locked room that runs SQL profiler.this computer is locked and the room is also locked. Go with the flow & have fun! Else fight the flow |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-02 : 19:58:41
|
| yep, you need a database manager, hiring for one? he he heon a serious note (huh? when's that?), those DBAs must have assignments like per project or per server, something like thatsince they'll have SA privilege, keeping a reign on them will be difficult but letting them be accountable for their actions will scare them enough not to do something naughty...--------------------keeping it simple... |
|
|
|
|
|
|
Do I need to?