Permission to restore databases and access them without being sysa

How can I give a user permissions on SQL Server 2000 so they can restore a
database (copied from the Production server) to the Test server, and get
access to the database they just restored? I assigned them to the dbcreator
server role and that lets them restore the database, but not access it.

The server is a test server, but there are several databases on it with
confidential content, so at the same time I need to make sure they cannot
gain access to those databases. For that reason, I can't put them in the
sysadmin server role.
.

Relevant Pages

  • Re: Problem with disable msde connection pool
    ... 'ALTER DATABASE TestDB SET single_user WITH ROLLBACK after 10 ... ' Restart the server... ... ' Execute query through SQLDMO to run the restore TSQL command ... the connection pool must be disabled. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Restore public folders and companyweb
    ... I understand that the Public Folder Store ... > database cannot be mounted due to integrity problems, ... > the pub.edb database from your backup of the old Server, ... please try the following steps to restore your public ...
    (microsoft.public.windows.server.sbs)
  • RE: Restore public folders and companyweb
    ... The new server must have the same domain name as the original server ... where the backup of the database. ... For the detailed steps to restore the SharePoint Services databases, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • 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: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)