BUILTIN/Administrators rights

From: A. Tolga KILINĒ (kilinc@tis.havelsan.com.tr)
Date: 09/06/02


From: "A. Tolga KILINĒ" <kilinc@tis.havelsan.com.tr>
Date: Fri, 6 Sep 2002 09:53:48 +0300


Hi,
is it possible that I give rights to BUILTIN/Administrators group such that:
they have no more system admin role,
they can take backups of the tables,
they can not modify database tables in any way,
they can delete the tables (to open space) "only" after they take the backup
of the table. (I want to prevent deleting tables before they are backed up
or archieved)

I think the last issue can be done by giving right to BUILTIN/Administrators
members to execute a stored procedure which deletes the table automatically
after it takes the backup of the table....Is it true? Is there any other
solution?

 There are default "dbo" statement in the properties part of the
BUILTIN/Administrators group and you can not change it, does this means they
are all full admin on tables?

Regards,
Tolga