-1

I am providing a .bak file to someone who as per my business scenario, may only be allowed to view the db ,and not modify anything in the database and may not even be allowed to take a backup of the database.

Is this possible ?

[Note : I have the privillege of restoring the .bak file to their SERVER]

ankur
  • 127
  • 1
  • 2
  • 10
  • 1
    What do you mean? The scenario doesn't make much sense. You can't `restore the .bak file to their SSMS`, SSMS is the IDE, not the database. If you give them a `bak` file they can copy it wherever they want. Will you restore it to their server or to one of your own and give them access? – Panagiotis Kanavos Feb 22 '16 at 12:29
  • 1
    NO. If the database is attached to a sql server there is no way to prevent an admin user from making a backup. There is also no way to prevent an admin user from doing whatever they want to the database. Preventing this kind of thing would go against the concept of an admin user in the first place. If you don't want somebody to be able to do things to your database don't put it on their server. – Sean Lange Feb 22 '16 at 14:05
  • @PanagiotisKanavos I meant in their server . Thanks Sean Lange – ankur Feb 23 '16 at 08:48
  • You must takeaway dbo privilegs from everyone (except yourself) and DENY ALL as well as remove write rights –  Feb 23 '16 at 08:54
  • @Sean Lange. Your comment looks like an answer. Why not make it an answer? I would upvote it. – Jesús López Feb 23 '16 at 08:54

1 Answers1

1

If the database is attached to a sql server there is no way to prevent an admin user from making a backup. There is also no way to prevent an admin user from doing whatever they want to the database. Preventing this kind of thing would go against the concept of an admin user in the first place. If you don't want somebody to be able to do things to your database don't put it on their server.

Sean Lange
  • 33,028
  • 3
  • 25
  • 40