Tables security

From: Ray Higdon (rayhigdon_at_higdonconsulting.com)
Date: 07/31/03

  • Next message: OV: "1433 listening from localhost only"
    Date: Wed, 30 Jul 2003 20:00:18 -0700
    
    

    You could place the table on a read only filegroup.

    HTH

    Ray Higdon MCSE, MCDBA, CCNA

    >-----Original Message-----
    >Hi all,
    > I created a table, this table's name is Customer, Fields
    are (CustomerID:nchar(10),CustomerName: Nchar(30)), in SQL
    Server. How way can lock this table, all users can not
    modify it. (if use Sql Server enterprise manager can not
    modifiy it).
    >
    >Thanks and Regards
    >
    >Thanh Le Van
    >
    >**********************************************************
    ************
    >Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
    >Comprehensive, categorised, searchable collection of
    links to ASP & ASP.NET resources...
    >.
    >


  • Next message: OV: "1433 listening from localhost only"

    Relevant Pages

    • Re: SQL Injectors
      ... >That top link by nexgenss is pretty comprehensive. ... >Ray Higdon MCSE, MCDBA, CCNA ...
      (microsoft.public.sqlserver.security)
    • Re: Parameters question
      ... >Ray Higdon MCSE, MCDBA, CCNA ... I changed the query to the following. ...
      (microsoft.public.sqlserver.programming)
    • Re: Books for SQL Analysis Server
      ... "Ray Higdon" wrote in message ... >> Ray Higdon MCSE, MCDBA, CCNA ...
      (microsoft.public.sqlserver.olap)
    • Re: Line Numbers in SQL
      ... > Ray Higdon MCSE, MCDBA, CCNA ...
      (microsoft.public.sqlserver.datawarehouse)
    • Re: Over-Protected
      ... Ask your network or DBA's to restore a backup for you. ... Ray Higdon MCSE, MCDBA, CCNA ...
      (microsoft.public.sqlserver.security)