Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Oracle Data Guard Functionality Expand / Collapse
Author
Message
Posted Monday, June 10, 2013 4:47 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:04 PM
Points: 215, Visits: 92
Hello all,
Does anyone know if the functionality of Oracle Data Guard (Separation of Duties) is available under SQL Server 2012?
Post #1461810
Posted Tuesday, June 11, 2013 2:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 1,240, Visits: 9,813
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?
Post #1461921
Posted Tuesday, June 11, 2013 10:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:04 PM
Points: 215, Visits: 92
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.
Post #1462266
Posted Tuesday, June 11, 2013 11:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 1,240, Visits: 9,813
Do you mean Database Vault rather than Data Guard? Data Guard is an HA/DR technology.
Post #1462292
Posted Tuesday, June 11, 2013 11:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:04 PM
Points: 215, Visits: 92
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?
Post #1462298
Posted Tuesday, June 11, 2013 12:00 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 1,240, Visits: 9,813
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
Post #1462306
Posted Tuesday, June 11, 2013 12:05 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 1:04 PM
Points: 215, Visits: 92
Thanks for your replies, I will definitely check this out!
Post #1462310
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse