How to DENY SELECT permission?

From: Lawrence (Lawrence_at_discussions.microsoft.com)
Date: 06/18/04 

Date: Thu, 17 Jun 2004 17:37:01 -0700

Hi,
I am dbo and sysadmin on this table that i'm trying to deny SELECT permission.
I tried the following code, but was still able to select the object. Any help is appreciated!

DENY SELECT
ON C_copy
TO dbo

select * from C_copy

-Lawrence

Relevant Pages

  • Re: How to hide INFORMATION_SCHEMA and sys from users
    ... at the database level but it is without any effect. ... The user still can see all the dbo, ... hongju a écrit : ... Revoke and Deny of various permissions does not seem to be working ...
    (microsoft.public.sqlserver.security)
  • Re: How to prevent DELETEs in a table
    ... What you say about dbo is true, but it is even MORE true about someone who ... is in the sysadmin role. ... No permissions are ever checked for someone in the ... the deny is not applied. ...
    (microsoft.public.sqlserver.server)
  • Re: How to DENY SELECT permissions?
    ... You cannot DENY from sysadmin. ... "Lawrence" wrote in message ... > I'm dbo & sysadmin on this table that I'm trying to take away SELECT permission. ...
    (microsoft.public.sqlserver.programming)
  • Re: DENY ALL for all tables
    ... To the best of my knowledge the default is NO permissions. ... > but it only works on tables belonging to the dbo owner. ... > one table at a time like DENY ON owner.tablename TO ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to prevent OU deletion by Domain Admins?
    ... > that DENY ACLs trump any allow ACLs ... Deny permissions take precedence over allow ... the list of permission entries in the DACL. ... I understand that domain admins have the delete and delete subtree rights at the domain level. ...
    (microsoft.public.win2000.active_directory)