How to DENY SELECT permissions?

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

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

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

  • Re: Help pls: Not allow users access to tables, stored procedures
    ... tables are owned by dbo. ... SQL Server MVP ... etc) is performed via stored procedures. ... correct permission for select permission on the tables. ...
    (microsoft.public.sqlserver.security)
  • Re: system tables security
    ... EM and look at the Database User Properties Permission for ... permissions for this user' the Owner dbo has Select, ... Insert, Update, Delete and DRI permission,, ... I checked the Server Properties Under Server behavior, ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... Try not to say "If sa is THE dbo", it's like saying "If I am the joe". ... might help to either say "If sa is the database owner" or, ... The login 'sa' could be listed in sysdatabases as the database ... FULL permission to do anything and everything. ...
    (microsoft.public.sqlserver.programming)
  • Re: db_owner role in SQL 2k
    ... DBO is just a user ... > I presume then that you are logged in as tfs. ... I am logged on to my server as tfs when I do the 2 selects ... permission - and tfs - which is sysadmin - I would have assumed that EM ...
    (microsoft.public.sqlserver.programming)
  • Re: how to give proper permission for asp.net in sql server express
    ... It may be easier to change the IIS user to one that has permission, ... > asp.net page with sql server express 2005 and always got some error msg ... > telling that the current nt account doen't have enough permission. ... > sp_grantdbaccess 'IUSR_MACHINE_NAME', 'DBO' ...
    (microsoft.public.dotnet.framework.aspnet)
Loading