Re: User rights

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Konstantinos Michas (anonymous_at_discussions.microsoft.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 04:22:36 -0700

Thanks for your response Wayne!

>-----Original Message-----
>Below from Books on Line, but the short answer is No..
>
>If the database being restored does not exist, the user
must have CREATE
>DATABASE permissions to be able to execute RESTORE. If
the database exists,
>RESTORE permissions default to members of the sysadmin
and dbcreator fixed
>server roles and the owner (dbo) of the database.
>
>RESTORE permissions are given to roles in which
membership information is
>always readily available to the server. Because fixed
database role
>membership can be checked only when the database is
accessible and
>undamaged, which is not always the case when RESTORE is
executed, members of
>the db_owner fixed database role do not have RESTORE
permissions.
>
>
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Mariner, Charlotte, NC
>www.mariner-usa.com
>(Please respond only to the newsgroups.)
>
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>
>
>"Konstantinos Michas"
<anonymous@discussions.microsoft.com> wrote in message
>news:1607201c447c6$b9479770$a601280a@phx.gbl...
>> Hello Experts,
>>
>> Can I create a user which only Restore a database?
>>
>> Thanks in advance!
>
>
>.
>

Relevant Pages

  • Re: unable to start SQL Service ... error code 3417
    ... How about just create a new instance and restore databases to the new instance? ... I wouldn't go with restoring master from another instance. ... The supported route is to rebuild your master database, start SQL Server in single user mode, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... want to run sp_updatestats after the restore or attach as well. ... >>There is a lot more that can go wrong with the wizard ... > SQL Server Databases ... >>Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.setup)
  • Re: HELP!!! restore database - left in loading state?? PLEASE H
    ... RESTORE DATABASE WITH RECOVERY ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.tools)
  • Re: Restore Master DB to New Server
    ... the user database will be suspect. ... Just drop them and then do the restore. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)