1
vote
1answer
91 views

Does MS SQL 2005 encryption protect data in the case of physical server access?

I am looking into MS SQL 2005 encryption (not 2008, so TDE is out), and I believe I understand the concept of how a column is encrypted. The OS uses the service credentials to encrypt the service ...
3
votes
4answers
465 views

Best practices for SQL Server audit trail

I'm facing a situation today where it would be very beneficial to me and my company if we knew who had logged into SQL and performed some deletions. We have a situation where at least 2 (sometimes 3) ...
2
votes
1answer
271 views

Why is SQL Server automatically creating an explicit user mapping for my local Administrator account in every new database I create?

If I login to a particular instance of SQL Server 2008 using a Windows domain user who is in the sysadmin role and I create a brand new database via SQL Management Studio, a user in the newly create ...
0
votes
1answer
713 views

Configuring MySQL logging for an audited environment such as SOX

How do you configure MySQL users and logging to satisfy SOX auditors? For example, if you need to log queries and the source of the query for later review by an internal SOX controls group. Is there ...
6
votes
2answers
32k views

Changing database owner in SQL Server 2008; CLR issues depending on method used?

I attached a database and tried changing the owner to a valid login. I used the statement: ALTER AUTHORIZATION ON database::my_db_name TO "sa". The database properties showed that the new owner was ...