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 |
|
carrlos
Starting Member
8 Posts |
 Posted - 2012-06-08 : 03:50:54
|
| Hi,Is it important to have database owner as sa? What if there is owner database as domain administrator - can it couse some troueble or unwanted troubles in future?Thanks for any suggestions |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-08 : 06:06:08
|
| Problem with a domain account is if it is deleted.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-06-08 : 10:42:01
|
| As a part of best practices you should not do that.A database owner should never have rights across the domain and that to admin rights on the domain.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
carrlos
Starting Member
8 Posts |
Posted - 2012-06-09 : 01:51:48
|
| Can I change it from domain administrator to SA without bad affects? |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-06-09 : 06:04:21
|
| Yes you can.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-06-09 : 06:19:10
|
| If you have a large amount of databases, think about running a regular audit to check this value - and make appropriate changesJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Database owner as "sa"