Re: Preventing database access from server..
- From: "Steve" <morriszone@xxxxxxxxxxx>
- Date: 21 Dec 2006 13:59:54 -0800
Create a Login for your assistant that does not belong to a server
role. Make that login a user in a database and a member of the
db_backupoperator role in that database.
Mrpush wrote:
Hello,
I'm a bit new to SQL, so bear with me please.
There is myself and an assitant in charge of our SQL server. I have 2
databases attached and I want to block my assistant from accessing one of
them.
How do I actually prevent him from accessing this other DB at all?
Note that he will however need to be able to BACK IT UP.
Is it possible to block all access of him opening tables or doing quiries
but allowing him to schedulae its backups (data and logs)?
Thanks much,
Mark
.
- Prev by Date: Re: Job owned by a non-sysadmin fails to run
- Next by Date: Locked out of server?
- Previous by thread: Restoring Databases with Encrypted Data to Another Server
- Next by thread: Locked out of server?
- Index(es):
Relevant Pages
|
