Monday, February 20, 2012

Preventing database access from server..

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,
MarkCreate 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

No comments:

Post a Comment