Re: Row Level Security

From: Christian Olsson (christian.olsson@protegrity.com)
Date: 08/23/02 

From: christian.olsson@protegrity.com (Christian Olsson)
Date: 22 Aug 2002 22:58:56 -0700

Secure.Data™ for SQL Server 2000 is an "out-of-the-box" automated
database encryption solution with protected key-management software
for selectively encrypting, securing and controlling access to
enterprise relational database information at the data-item level.
This database security solution is application transparent, which
allows for fast integration, rapid execution, cost-effective security
and privacy compliance. The Solution provides an effective last line
of defense:
 
· Selective and highly secure, column-level data item
encryption

· Cryptographically enforced authorization

· Comprehensive key management

· Secure audit and reporting facility

· Enforced separation of duties

· Interoperability with other security technologies

· Operational transparency to applications

For more info see: www.protegrity.com/microsoft

Sue Hoegemeier <Sue_H@nomail.please> wrote in message news:<ra70kuctmb1q2gabm85k4r751gg5oo4veg@4ax.com>...
> SQL Server doesn't support row level security directly so
> you need to come up with your own methods through views,
> stored procedures. How you do it really depends on a lot of
> factors. This link gives an example of one approach to this:
> http://vyaskn.tripod.com/row_level_security_in_sql_server_databases.htm
>
> -Sue
>
> On Thu, 25 Jul 2002 08:17:23 -0700, "Marcos M Zorola"
> <mzorola@saisd.net> wrote:
>
> >What is the best method to implement row-level security on
> >SQL Server 2000?

Relevant Pages

  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Cryptography in SQL Server 2000
    ... A company is vulnerable when its security ... > database encryption solution with protected key-management software ... > tested by the SQL Server Test Lab. ...
    (microsoft.public.sqlserver.security)
  • Re: How to prevent importing tables
    ... why in-built encryption doesn't even matter if they otherwise have ... off-topic but is all to do with security and "extraction". ... > sufficient permission to open the database, ... then they don't even need to decrypt it! ...
    (microsoft.public.access.security)
  • Re: Which is more secure RC2 or RC4 ?
    ... form to place the order with their credit card. ... same database temporarily, until the order is approved manually and the ... If by MSSQL you mean SQLServer by microsoft, they got a security concept ... bothering about encryption, use microsoft's stuff for that and spend ...
    (sci.crypt)
  • Re: setting a password on a button on the switchboard
    ... Could you send me the sample database for the fourth option (4. ... > Security in an Access database can probably be broken down into two big ... > points about being easier than User Level Security, ... > What type of data are you trying to protect? ...
    (microsoft.public.access.forms)