Post reply

Granting the permissions to the in SQL Server 2005 Express edition

  • July 16, 2010 at 1:20 am

    #221353

    Hi All,

    I need to create a user in SQL Server 2005 Express Edition. That user should have the permission for taking and restoring the backup of database alone. He shouldn't have the admin rights and he shouldn't access the other databases also.

    I tried with giving the "dbcreator" permissions. But still i can't restore the database.

    Is it possible. If it is kindly explain me how to do this.

    Thanks in advance.

    Regards

  • July 16, 2010 at 1:44 am

    #1193918

    Instead of explaining only whats needed for backups, read this, would explain all roles much better..

    http://articles.techrepublic.com.com/5100-10878_11-1061781.html

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 2 posts - 1 through 2 (of 2 total)

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