Post reply

Give a developer access to a copy of your database for only 24 hours?

  • March 11, 2011 at 8:14 am

    #233228

    Hi all,

    Just wondering,

    is it possible to give a developer a copy of a SQL database, in the form of a backup maybe, they restore it to another server and you supply a password with which they can log in but will only grant them access for a day or other length of time?

    Thanks in advance

  • March 11, 2011 at 8:19 am

    #1297657

    I suppose you could create a job on the second server that removes that login's access to your database at a specified time.

    John

  • March 11, 2011 at 8:44 am

    #1297689

    Do you have SA access and control over the second server? if so you could do something like John has suggested..

    otherwise i dont think there is anything you can do to the actaul backup file to make it self-destruct within 24hrs

  • March 11, 2011 at 8:54 am

    #1297700

    There's no way to remove access from within the database. It's contained on the server, and the server determines access, as of SS2K8R2. If they are restoring the database, then they likely will have control over how long it's there. Also, they'll have the backup file. If you give it to them, you lose control.

    You can restore it on your instance, give them a login, and have that login be disabled after xx time with a job.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

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

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