Re: permit RESTORE

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 02/27/04

  • Next message: AG: "SSL setup problems" 
    Date: Fri, 27 Feb 2004 20:36:31 +0530

    Hi,

    No, "RESTORE DATABASE " can not be granted . User has to be part of any of
    the below roles to perform a restore,

    1. Systemadmin
    2. dbcreator
    3. db_owner

    Thanks
    Hari
    MCDAB

    "Joachim Hofmann" <speicher@freenet.de> wrote in message
    news:403F4BF5.ADE7C3FE@freenet.de...
    > Hello,
    >
    > is it possible to grant a "normal" user the right to RESTORE a special
    Database?
    >
    > Thank You
    >
    > Joachim

  • Next message: AG: "SSL setup problems"

    Relevant Pages

    • Re: Deleted versions of DTS package
      ... Have to restore it the hard ... Regards ... Joachim ... "Narayana Vyas Kondreddi" wrote: ...
      (microsoft.public.sqlserver.dts)
    • Re: Acronis True Image 8
      ... Prüflauf ob die Daten des BAckup´s mit dem Original übereinstimmen. ... das auch ein Restore dieser Daten ... Tschau ... Joachim Conrad ...
      (microsoft.public.de.german.windowsxp.applications)
    • restore permissions (Access .adp project using MSDE)
      ... project but cannot get it to do a restore unless I give ... high level (dbcreator) permissions to the login account. ...
      (microsoft.public.sqlserver.security)
    • permit RESTORE
      ... is it possible to grant a "normal" user the right to RESTORE a special Database? ... Joachim ...
      (microsoft.public.sqlserver.security)