Re: How to DENY SELECT permissions?

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/18/04 

Date: Fri, 18 Jun 2004 11:06:28 +0200

This Q has already been answered. You cannot DENY from sysadmin. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lawrence" <Lawrence@discussions.microsoft.com> wrote in message
news:6612724A-EEA5-4E05-BF7A-4AB154FDFFC2@microsoft.com...
> Hi,
> I'm dbo & sysadmin on this table that I'm trying to take away SELECT permission.  How do I do
that?  I tried the followin code, but was still able to select the records.
>
> DENY SELECT
> ON C_copy
> TO dbo
>
> select * from C_copy
>
> Any help is appreciated!
> -Lawrence

Relevant Pages

  • How to DENY SELECT permission?
    ... I am dbo and sysadmin on this table that i'm trying to deny SELECT permission. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to DENY SELECT permission?
    ... For users under Sysadmin role we cant DENY the previlages. ... "Lawrence" wrote in message ... > I am dbo and sysadmin on this table that i'm trying to deny SELECT ...
    (microsoft.public.sqlserver.programming)
  • Re: MS Access cant find Recordsource object
    ... are owned by dbo. ... system stored procedure on those objects. ... >For several reports and forms I have the recordset property set to the name ... If I give those users sysadmin privileges, ...
    (microsoft.public.sqlserver.server)
  • 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: Alter User for domain user
    ... Any member of sysadmin will always be the dbo inside a DB. ... connect to the server with Windows Authentication, the default schema ...
    (microsoft.public.sqlserver.security)