Re: Inactive record

From: Jens Süßmeyer (Jens_at_Remove_this_For_Contacting.sqlserver2005.de)
Date: 04/27/05

  • Next message: Paul: "Re: Inactive record" 
    Date: Wed, 27 Apr 2005 17:25:31 +0200

    Sorry, i mean : No there is no row level security based on SQL Server 2000.

    "Jens Süßmeyer" <Jens@Remove_this_For_Contacting.sqlserver2005.de> schrieb
    im Newsbeitrag news:eNTxiwzSFHA.612@TK2MSFTNGP12.phx.gbl...
    > No there is now row level security based on SQL Server 2000.
    >
    > HTH, Jens Suessmeyer.
    >
    >
    > ---
    > http://www.sqlserver2005.de
    > ---
    >
    > "Paul" <Paul@discussions.microsoft.com> schrieb im Newsbeitrag
    > news:BD1A992D-4723-48EA-82C1-7CF94A102258@microsoft.com...
    >> Hi just wondering if there is a way to have one record in a table be read
    >> only, were an application can not remove it and have all other records
    >> act
    >> normally? I am currently handling this in .net code but would prefer to
    >> have it built into the table.
    >> thanks.
    >> --
    >> Paul G
    >> Software engineer.
    >
    >

  • Next message: Paul: "Re: Inactive record"

    Relevant Pages

    • Re: Row based security
      ... > "Simon Worth" wrote: ... >> I have a solution in place for row level security using stored ... >> In the Oracle world, row based security is handled, but in SQL Server ... >> is no mechanism in place within the security model to accommodate for ...
      (microsoft.public.sqlserver.security)
    • SQL SEcurity
      ... How do I implement Row Level Security using SQL ... ANS2:There is a topic in SQL Server Books Online titled ... as "SQL Stored Procedures" within that topic it explains ... for all SQL statements in the procedure cache, ...
      (microsoft.public.sqlserver.security)
    • Row based security
      ... I have a database system that contains 1 category of data. ... I have a solution in place for row level security using stored procedures ... In the Oracle world, row based security is handled, but in SQL Server there ... What are some approaches in SQL Server that others have used to accommodate ...
      (microsoft.public.sqlserver.security)
    • =?iso-8859-1?Q?Re:_SQL_2000_Logfile_Sicherung_nicht_m=F6glich?=
      ... "Olaf Pietsch" schrieb im Newsbeitrag ... SQL Server Enterprise Manager Help ...
      (microsoft.public.de.sqlserver)
    • Re: Analysis Services on Developer Edition
      ... schrieb im Newsbeitrag ... > Can i Install Analysis Services on SQL Server 2000 Developer Edition? ...
      (microsoft.public.sqlserver.setup)