Re: deny a user's ability to SELECT

Hi Roger,

No, this is a user that was created with 'CREATE USER'
I can only use deny with Windows authenticated users?


"Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23keGszcLGHA.3496@xxxxxxxxxxxxxxxxxxxxxxx
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: 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)
  • Re: deny a users ability to SELECT
    ... If so, deny won't work. ... This posting is provided "AS IS" with no warranties, ... This gives the user access to SELECT from my tables. ... 'SELECT' option in the 'Explicit permissions for ' ...
    (microsoft.public.sqlserver.security)