Prevent outsource user copy data

Question

Post reply

Prevent outsource user copy data

mamdoh

Right there with Babe

Points: 714
More actions
June 2, 2007 at 12:28 pm

#103367

Hello everybody,
We have outsource company whom given a privilege to access one of the database as an owner. What should I do to make sure that the user does not copy the data (one table or the whole database).
I look forward to hearing from you

Viewing 5 posts - 1 through 4 (of 4 total)

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

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

Removing the "owner" privs is the only way... unless you encrypt everything.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

mamdoh Right there with Babe Points: 714 More actions · Answer 2

They need to have privilege to view, update,create table...etc. This outsource company is the developer of one of the software we have and they need to access the database for maintenance reason. I just want a trick to make sure that our data does not copy and transfer to them location.

is there any idea?

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 3

Understood... I don't think there's a trick to do this or monitor this in 2k... if they can view the data, they can copy the data.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLBill SSC Guru Points: 51440 More actions · Answer 4

You've made them 'owners' of the data. That means it is their data also as far as SQL Server is concerned.

-SQLBill