Re: Enterprise Manager and Windows Account

From: SQL Server Development Team [MS] (sqldev@microsoft.com)
Date: 12/02/02 

From: "SQL Server Development Team [MS]" <sqldev@microsoft.com>
Date: Mon, 2 Dec 2002 10:07:58 -0800

No, members of db_backupoperator can't necessarily see data in tables
(unless select on the tables/views has been granted to public since as a
database user he will also be a member of PUBLIC). However, this doesn't
confer any rights to restore. In order to restore a database you'll need to
make him a member of the db_owner role. Even that won't give you full
restore capabilities if you ever have to drop/recreate the database and then
restore (for that he'll need to be in the dbcreator fixed server role).

-Richard Waymire 

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Tabassum" <Tabassum@sys.net.pk> wrote in message
news:ecqywPslCHA.1588@tkmsftngp02...
> Dear All,
>
> I wanted to a samll question about security in enterprise manager and
normal
> user accounts.
>
> I have SQL2k on win2k server and normally all administration work is the
> carried out using administrator account. my manage wants to give backup
and
> restore task to a newly hired person in our organization, but he do not
want
> to give the admin password to him
>
> His account is in the USERS group in Win2k
>
> I have to add the user (with his login) in the required database and
assign
> him the backup operator role.??
>
> I also want to know if i give him backup operator role can he access the
> data in tables by opening them in EM?
>
> an early response will be highly appreciated.
>
> kind regards
> Tabassum
>
>

Relevant Pages

  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: HOME BASED JOB OPPORTUNITY - MAKE MILLIONS WITH Rs.60!
    ... Free entry into draw. ... > THIS CAN REALLY MAKE YOU EASY MONEY! ... Try to Remember that you don`t change the Main Database ... > mail/courier with money to the main member and to the other 5 upline ...
    (soc.culture.indian.gujarati)
  • Re: HOME BASED JOB OPPORTUNITY - MAKE MILLIONS WITH Rs.60!
    ... Free entry into draw. ... > THIS CAN REALLY MAKE YOU EASY MONEY! ... Try to Remember that you don`t change the Main Database ... > mail/courier with money to the main member and to the other 5 upline ...
    (soc.culture.indian.karnataka)
  • Re: HOME BASED JOB OPPORTUNITY - MAKE MILLIONS WITH Rs.60!
    ... Free entry into draw. ... > THIS CAN REALLY MAKE YOU EASY MONEY! ... Try to Remember that you don`t change the Main Database ... > mail/courier with money to the main member and to the other 5 upline ...
    (soc.culture.indian.karnataka)