Re: deny a user's ability to SELECT

Is this user using Windows authentication and if so is the user and
Administrator on the box? If so, deny won't work.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Steve" <sss@xxxxxxx> wrote in message
news:es2jWwbLGHA.1124@xxxxxxxxxxxxxxxxxxxxxxx
using Sql Server 2005 Express

I have created a new user and added them to the db_datareader role.

This gives the user access to SELECT from my tables. As a test, I wanted
to deny them access to a certain table, so I went into the
properties->permissions for the table and checked the 'Deny' option on the
'SELECT' option in the 'Explicit permissions for <username>'

The user is still allowed to perform a SELECT on the table. What am I
missing? I haven't ever modified permissions before, all my apps before
were for 1 user.

Thanks for reading,
Steve



.

Relevant Pages

  • Re: Password Protect a Folder?
    ... use file security and permissions to allow or deny a user access to files or ... folders. ... deny as you like for the user you want to deny or allow. ...
    (microsoft.public.windowsxp.general)
  • Re: deny a users ability to SELECT
    ... I can only use deny with Windows authenticated users? ... Administrator on the box? ... This gives the user access to SELECT from my tables. ... the 'SELECT' option in the 'Explicit permissions for ' ...
    (microsoft.public.sqlserver.security)
  • Re: Basic Authentication for only one special user
    ... Authentication is the process of identifying the user. ... What you want to do is deny the user access to things based on their ... I have a Win2003 Server with IIS 6 in an intranet environment and i want ...
    (microsoft.public.inetserver.iis.security)
  • Re: Deny access to tables
    ... Michelle ... >Have a look into DENY statement in Books online ... >Sample statement to deny all revilages on emp_master ... >> How do you allow a user access to a database but ...
    (microsoft.public.sqlserver.security)
  • deny a users ability to SELECT
    ... using Sql Server 2005 Express ... This gives the user access to SELECT from my tables. ... properties->permissions for the table and checked the 'Deny' option on the ... 'SELECT' option in the 'Explicit permissions for ' ...
    (microsoft.public.sqlserver.security)