<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
Can you prent a DBA from viewing the data ?
16 posts, Page 1 of 2
1
2
»»
Can you prent a DBA from viewing the data ?
Rate Topic
Display Mode
Topic Options
Author
Message
lianvh
lianvh
Posted Thursday, August 02, 2012 1:29 AM
SSC 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
MysteryJimbo
MysteryJimbo
Posted Thursday, August 02, 2012 1:38 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 6:28 AM
Points: 1,125,
Visits: 14,511
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
MysteryJimbo
MysteryJimbo
Posted Thursday, August 02, 2012 1:39 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 6:28 AM
Points: 1,125,
Visits: 14,511
Another thought. Sensitive data could also be encrypted.
Post #1338987
DBA328
DBA328
Posted Thursday, August 02, 2012 3:04 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 2:13 AM
Points: 116,
Visits: 792
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
SQLKnowItAll
SQLKnowItAll
Posted Thursday, August 02, 2012 6:11 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 1:51 PM
Points: 2,613,
Visits: 3,126
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
Lowell
Lowell
Posted Thursday, August 02, 2012 6:28 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 8:39 PM
Points: 11,638,
Visits: 27,713
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
DBA328
DBA328
Posted Thursday, August 02, 2012 7:02 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 2:13 AM
Points: 116,
Visits: 792
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
Lowell
Lowell
Posted Thursday, August 02, 2012 7:09 AM
SSChampion
Group: General Forum Members
Last Login: Today @ 8:39 PM
Points: 11,638,
Visits: 27,713
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
Evil Kraig F
Evil Kraig F
Posted Thursday, August 02, 2012 2:11 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 5:44 PM
Points: 5,677,
Visits: 6,124
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
PaulB-TheOneAndOnly
PaulB-TheOneAndOnly
Posted Thursday, August 02, 2012 2:16 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 2,984,
Visits: 4,403
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 »
16 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
