MS SQL Server - Denying table acccess permisions

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Denying table acccess permisions

sudmill@yahoo.co.uk

2005-07-29, 9:23 am

Hi,

I have setup a Windows NT group 'ADGroup Developers' with public,
DB_datareader and db_datawriter and db_ddladmin role access to a
database.
Certain tables in this database need to be retired, so as an interim
measure I have granted a deny to public

DENY SELECT, UPDATE, DELETE, INSERT ON <tablename> TO PUBLIC

however users of this group can still select from this table. I thought
DENY on public overrides all grants (implicit or explicit?).

Becuase I have mainly granted permissions through reader or writer
roles to users, how can I make these table unavailable without
resorting to removing / renaming them ?

Cheers,

JE.

Sponsored Links