Oracle Data Guard Functionality

Question

Oracle Data Guard Functionality

rcheneyjr

Mr or Mrs. 500

Points: 549
More actions
June 10, 2013 at 4:47 pm

#294314

Hello all,
Does anyone know if the functionality of Oracle Data Guard (Separation of Duties) is available under SQL Server 2012?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

HowardW One Orange Chip Points: 29109 More actions · Answer 1

Mirroring or AlwaysOn would be the equivalent of Data Guard in SQL Server, although it has some fundamental differences (e.g. it's at the level of an individual database, rather than a whole instance).

Not sure what you mean by "seperation of duties" in relation to Data Guard. That term relates to security and organisational practices? Do you mean "Shared Nothing Architecture", or am I misunderstanding?

rcheneyjr Mr or Mrs. 500 Points: 549 More actions · Answer 2

Thanks for your reply. What I meant by 'Separation of Duties' was the ability to block sensitive data from being viewed by sysadmins. This can be done in Oracle via Data Guard.

HowardW One Orange Chip Points: 29109 More actions · Answer 3

Do you mean Database Vault rather than Data Guard? Data Guard is an HA/DR technology.

rcheneyjr Mr or Mrs. 500 Points: 549 More actions · Answer 4

Yes, yes! Arggghhhhh! My bad, sorry for the confusion, too much going on here!

Let me rephrase, does SQL Seriver 2012 have functionality similar to Oracle Database Vault?

HowardW One Orange Chip Points: 29109 More actions · Answer 5

Not in the same way as Oracle, as in a pre-packaged set of configurations, permissions and audit rules, but it has all the constituent parts in order to configure this.

A good resource to start with would be this:

http://download.microsoft.com/download/D/2/D/D2D931E9-B6B5-4E3B-B0AF-22C749F9BB7E/SQL_Server_Separation_of_Duties_White_Paper_Jul2011.docx

rcheneyjr Mr or Mrs. 500 Points: 549 More actions · Answer 6

Thanks for your replies, I will definitely check this out!