security table in sqlserver 2000

From: P Vaddi (Shastry.vaddi_at_enron.com)
Date: 07/30/03 

Date: Wed, 30 Jul 2003 11:35:42 -0700

Go to the table properties and permissions and deny the
access to every one except you. You can also deny for your
login in you have the Sysadmin rights on the box. Sysadmin
overwrites rest of the permissions

>-----Original Message-----
>I have a table in a database of sqlserver 2000. I want to
protect this table, that mean all user can not modify it
(not rename,addnew or delete all fileds in this table, and
can not see table's structre)by sql server manager or
other ways. How way do it.
>
>
>**********************************************************
************
>Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
>Comprehensive, categorised, searchable collection of
links to ASP & ASP.NET resources...
>.
>

Relevant Pages

  • Re: Save me from my stupidity
    ... added 'AuthenticatedUsers' and set the permissions to: ... AuthenticatedUsers: deny full ... I could still not login locally. ...
    (microsoft.public.security)
  • Re: how to restrict users to search in their own Organizational Unit
    ... I also want to say that in fact you shouldn't deny the read permission to anyone and this scenario the MOSS Administrators or who is responsible for Add users to Your Sites should be carefull when performing this action. ... Now, because you're dealing with many users, my recommendation is to create THE NECESARY Security Groups in each OU and related them with your MOSS2007 existing security groups, in future when someone creates some user, you just have to add that user to the necessary group and that user will be given the necessary permissions. ... decided a script can make it possible to accomplish, ... > If I need to create a security group per OU and then add all users ...
    (microsoft.public.windows.server.active_directory)
  • Re: Share Permissions: Deny behaviour
    ... Deny overrides all other permissions. ... There are two types of Deny (again goes for share and NTFS). ... explicit allow permission, then you're stuck with implicit deny. ...
    (microsoft.public.windows.server.general)
  • Re: how to restrict users to search in their own Organizational Unit
    ... decided a script can make it possible to accomplish, ... You could also TRY removing the "Authenticated Users" ... Domain level since using a lot of DENY ... permissions is in and of itself a poor practice. ...
    (microsoft.public.windows.server.active_directory)
  • Re: NTFS Security Question.
    ... I was not sure that deleting the special permissions would work but you ... Since Windows 2000 deny NTFS permission does not work ... originally configured "closer" to the object in the chain of folders. ...
    (microsoft.public.windowsxp.security_admin)