Re: How do I drop DBO access to a DB?
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Sun, 16 Nov 2008 09:54:34 +0200
Hi
Because those users are members of db_owner database role or even sysdamin
on the instance?
Remove them from db_owner database role and make them to login with
separate login to the instance
"TLuebke" <TLuebke@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5039128D-0650-4825-881E-D9E8ABA54AF1@xxxxxxxxxxxxxxxx
I'm running an SQL 2005 in a classroom environment. Students are allowed
to
create databases and did so last night for a test. The instructor wants me
to
deny them access to the DB's they created so she can grade them. I can't
seem
to drop them from their DB's because they are linked as DBO.
How do I deny them access to a particular DB that they created?
I've tried sp_changedowner, revoke access and a few other scripts.
.
- References:
- How do I drop DBO access to a DB?
- From: TLuebke
- How do I drop DBO access to a DB?
- Prev by Date: Re: Do I need to grant permissions to table as well as view?
- Next by Date: Re: SQL and Windows Firewall
- Previous by thread: How do I drop DBO access to a DB?
- Next by thread: Re: How do I drop DBO access to a DB?
- Index(es):
Relevant Pages
|
