Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesHi, 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.
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread