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 12»»

Can you prent a DBA from viewing the data ? Expand / Collapse
Author
Message
Posted Thursday, August 2, 2012 1:29 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 28, 2012 3:18 AM
Points: 45, Visits: 394
Good Day ,
our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather invest in audit trail software that sends out a notification when certain userids are accessing the data ? Any ideas ?
Post #1338977
Posted Thursday, August 2, 2012 1:38 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:04 AM
Points: 1,331, Visits: 15,269
lianvh (8/2/2012)
Good Day ,
our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather invest in audit trail software that sends out a notification when certain userids are accessing the data ? Any ideas ?


I think its overkill from an auditors perspective. There is no real way to prevent a DBA from viewing data without potentially restricting their ability to do their job.

Having worked in the strictly regulated finance industry I can say that viewing data is different to fully understanding data. Segregation of duties provides this distance where required and possible.

Alternatively you should be auditing all DBA access to data and/or systems so that an explanation of why they did this and when can be traced to a change request.
Post #1338985
Posted Thursday, August 2, 2012 1:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:04 AM
Points: 1,331, Visits: 15,269
Another thought. Sensitive data could also be encrypted.
Post #1338987
Posted Thursday, August 2, 2012 3:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 27, 2014 7:30 PM
Points: 126, Visits: 1,090
If you don't want your DBA to view data, you could restrict his permission, not grant sysadmin or database role.
If couldn't then use encryption and audit tools.


[li][/li]
Post #1339020
Posted Thursday, August 2, 2012 6:11 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 4, 2014 10:09 AM
Points: 2,706, Visits: 3,427
DBA328 (8/2/2012)
If you don't want your DBA to view data, you could restrict his permission, not grant sysadmin or database role.
If couldn't then use encryption and audit tools.
And how does one administer the server without sysadmin? OP, you have to explain to the auditor that the DBA must have access to everything. Sensitive data should always be encrypted, but who will do the encryption? I think your auditor doesn't know what he/she is doing. You must explain to them that the DBA is the top of the chain for data. If it is sensitive data that shouldn't be encrypted (HR stuff for example), then the DBA must be a trusted individual in the company. The auditor shouldn't care who has access to the data as long as the person having access is in the DBA or HR role. When I managed this type of data, I had a brief session with HR to fully understand my role in protecting the data and the sensitivity of it. Imagine telling someone that they are responsible for guarding what is in a room, but the room is locked and they don't have the key. When someone with a key comes, how do you know what they are taking in and out?


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1339080
Posted Thursday, August 2, 2012 6:28 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 12,953, Visits: 32,483
SQLKnowItAll (8/2/2012)
Imagine telling someone that they are responsible for guarding what is in a room, but the room is locked and they don't have the key. When someone with a key comes, how do you know what they are taking in and out?

i like that analogy.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1339089
Posted Thursday, August 2, 2012 7:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 27, 2014 7:30 PM
Points: 126, Visits: 1,090
Oracle has a SYSOPER privilege allows opration such as:
instance startup,mount & database open;
alter database backup archive log and restore
This privilege allows the user to perform basic operational tasks without the ability look user data.

I know this SYSOPER could limit DBA powers, but some company has different DBA roles. And it better not allow DBA to access database directlly after application implemantation.


[li][/li]
Post #1339119
Posted Thursday, August 2, 2012 7:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:33 PM
Points: 12,953, Visits: 32,483
DBA328 (8/2/2012)
Oracle has a SYSOPER privilege allows opration such as:
instance startup,mount & database open;
alter database backup archive log and restore
This privilege allows the user to perform basic operational tasks without the ability look user data.

I know this SYSOPER could limit DBA powers, but some company has different DBA roles. And it better not allow DBA to access database directlly after application implemantation.


SQL server has the same equivilents...if i need someone who only is going to do operating system backups, i can assign the proper roles. The issue is the sysadmin role itself. someone needs to be in that role, even if it is unused, in order to actually do administration.

kind of like saying the person who is the president of the company should not have access to the financial information of the company, because he could abuse it.

As said in thousands of similar posts here: if you cannot trust the person in the role, remove the person.





Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1339129
Posted Thursday, August 2, 2012 2:11 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:26 PM
Points: 5,466, Visits: 7,647
lianvh (8/2/2012)
Good Day ,
our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather invest in audit trail software that sends out a notification when certain userids are accessing the data ? Any ideas ?


DBA/Database administrator is a very loosely defined term these days. What particular duties do the database administrators you're trying to restrict need to perform?



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1339509
Posted Thursday, August 2, 2012 2:16 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,065, Visits: 4,639
lianvh (8/2/2012)
...our IT Auditors suggested the database administrators should not be able to view the Production data . Is there way to do that or should we rather invest in audit trail software that sends out a notification when certain userids are accessing the data ? Any ideas ?


It all depends on the technology. As far as I know it is not possible to do it (yet) on SQL Server but Oracle has a working solution for it, Oracle vault.


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1339512
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse