Re: archive database rights

From: Ron Talmage (rtalmage@prospice.com)
Date: 09/06/02 

From: "Ron Talmage" <rtalmage@prospice.com>
Date: Thu, 5 Sep 2002 22:06:40 -0700

Tolga,

1. If you make the login a member of the db_backupoperator database role,
that user will be able to back it up. I believe that's what you mean by
'archiving'.

2. When you are in mixed mode and deny or delete BUILTIN\Administrators,
then sa and any other login with the system administrator server role are
system administrators.

Ron 

--
Ron Talmage
SQL Server MVP
"A. Tolga KILINĒ" <kilinc@tis.havelsan.com.tr> wrote in message
news:ed4kmtLVCHA.2452@tkmsftngp09...
> Hi,
> I want a user in my domain (or in SQL) to access to SQL tables "only" for
> archiving them, I don't want him to delete/change tables (at least before
> archiving the tables on a media).
> I gave deny to BUILTIN/Administrators group. I use mixed mode
authentication
> (I have sa account active).
> Is there any solution to this?
> Secondly, at this configuration who is the system admin of SQL? sa, or
> noone?
> Regards,
> Tolga
>
>