Re: Deny access to tables

anonymous_at_discussions.microsoft.com
Date: 06/07/04

  • Next message: nasteric: "Re: Does Force Protocol Encryption on Server Require Certificate to be Installed on Client?" 
    Date: Mon, 7 Jun 2004 08:53:06 -0700

    Hari,

    Thanks for that, I thought that a script might be what
    was required.

    Thanks for all your help.

    Michelle
    >-----Original Message-----
    >Hi;
    >
    >Have a look into DENY statement in Books online
    >
    >Sample statement to deny all revilages on emp_master
    table from user : test
    >
    >DENY all on emp_master to test
    >
    >Thanks
    >Hari
    >MCDBA
    >
    >"Michelle T" <anonymous@discussions.microsoft.com> wrote
    in message
    >news:192e801c44c78$5252a170$a001280a@phx.gbl...
    >> Hi,
    >>
    >> I was hoping someone could help me with a problem I
    have
    >> in SQL 2000, I'm an old SQL7 DBA and I haven't used SQL
    >> Server in a few years, so I'm quite rusty.
    >>
    >> How do you allow a user access to a database but
    restrict
    >> what tables they can see/edit. The problem I'm
    >> experiencing is the Public role, I can't seem to delete
    >> it and I don't want to change it's permissions as all
    the
    >> other users need access to the tables it allows..
    >>
    >> Any help - I'm probably missing something so basic and
    >> will kick myself.
    >>
    >> Many thanks in advance for any help received.
    >>
    >> Michelle
    >>
    >
    >
    >.
    >

  • Next message: nasteric: "Re: Does Force Protocol Encryption on Server Require Certificate to be Installed on Client?"

    Relevant Pages

    • Re: Deny access to tables
      ... Have a look into DENY statement in Books online ... Sample statement to deny all revilages on emp_master table from user: ... > How do you allow a user access to a database but restrict ...
      (microsoft.public.sqlserver.security)
    • 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 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)
    • 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)