BUILTIN/Administrators rights
From: A. Tolga KILINĒ (kilinc@tis.havelsan.com.tr)
Date: 09/06/02
- Next message: Jeremy Byrski: "Re: VB apps connecting directly to SQL 2000 via Internet"
- Previous message: A. Tolga KILINĒ: "Re: archive database rights"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: Jeremy Byrski: "Re: VB apps connecting directly to SQL 2000 via Internet"
- Previous message: A. Tolga KILINĒ: "Re: archive database rights"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]