Re: Protecting database from administrators

From: Neil Pike (neilpike_at_compuserve.com)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 19:01:51 GMT

 Hi Andre,
 
 You're probably lucky that you're marketting at companies mainly without
DBA's. Some/many companies with DBA's would insist on your product working
with their "standard" dbms (Oracle, DB2, MSSQL etc.) and wouldn't consider
using it if it didn't.
 
> I am sure that this thread will not be the last one to
> bring up this matter as it is an obvious problem to many. A cursory review
> of this forum will confirm that it has come up a number of times. Thanks
> for the input. This is really a helpful forum.

 You're not the first looking for better security features, and you won't be
the last I'm sure! But, in their defence, MS want SQL Server as a mass-market
dbms, so they put their resources into features that will earn them the most
revenue/market share. (As would any sensible company seeking to make a profit,
let's be honest!). That's not to say they won't be putting more "security"
features into SQL Server, because, absolutely they will, but how many
people/companies actually need the level of security/encryption that you're
looking for?
 
 Anyway, good luck with the investigations, and please report back on your
results.
 
 Neil Pike MVP/MCSE. Protech Computing Ltd
 Reply here - no email
 SQL FAQ (484 entries) see
 http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
 (faqxxx.zip in lib 7)
 or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
 or www.sqlserverfaq.com
 or www.mssqlserver.com/faq

Relevant Pages

  • Re: Conceptual, Logical, and Physical views of data
    ... Frank Hamersley wrote: ... >>> Tables and indexes port very readily from one SQL DBMS to another. ... >>> features are generic. ... >> the relational model now that the relational model seems to have ...
    (comp.databases.theory)
  • Re: Object Oriented Concurrency
    ... the relational model is orthogonal to concurrency features. ... happens to be tailored expressly to the RAD CRUD/USER realm. ... since the only thing a DBMS do is to manage data. ...
    (comp.object)
  • Re: ConnectionString using DSN not working
    ... applications that can work regardless of which backend database engine is ... This assumes that each DBMS is the same--supports the same SQL ... take advantage of the specific features you pay for when you buy SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Object Oriented Concurrency
    ... the relational model is orthogonal to concurrency features. ... happens to be tailored expressly to the RAD CRUD/USER realm. ... since the only thing a DBMS do is to manage data. ...
    (comp.object)
  • Re: Selective views
    ... MS Access is an interactive, client interface for the MS Jet, ... semi-relational DBMS. ... If you create a MS Access database with links to SQL Server or pass-through ...
    (microsoft.public.sqlserver.server)