[dba-SQLServer] Security & encryption (cross posted to accessd&dba-sql)

hey... you're describing A sales guy (now over the pond) where I work ;)

On 5/10/05, dmcafee at pacbell.net <dmcafee at pacbell.net> wrote:
> 
> Since HR doesn't have access to the development tools, can't they just be
> led to believe that it "is" encrypted for the developer? If the Jedi mind
> trick doesn't work on them, maybe a faux page made up to display 
> "encrypted"
> data could be show to them.
> 
> Sometimes, you have to make them think you did what they asked/wanted, 
> even
> though you know better, like when a sales manager wants to tell you how to
> make the table structure.
> 
> David
> 
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of
> Charlotte Foust
> Sent: Tuesday, May 10, 2005 8:14 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: RE: [dba-SQLServer] Security & encryption (cross posted to
> accessd&dba-sql)
> 
> It doesn't really make sense to build a database that the dba is locked
> out of. I've seen discussions of this HR wish before, but I've never
> seen a good answer for it.
> 
> Charlotte Foust
> 
> -----Original Message-----
> From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
> Sent: Tuesday, May 10, 2005 2:05 AM
> To: 'Access Developers discussion and problem solving';
> 'dba-sqlserver at databaseadvisors.com'
> Subject: [dba-SQLServer] Security & encryption (cross posted to accessd
> &dba-sql)
> 
> Hi all
> 
> This may or may not be slightly OT... We have been asked by our HR
> department whether it's possible for us to build a storage facility for
> confidential data (such as salary information), that is encrypted and
> that neither we nor the network administrators could get into once it's
> gone live. Ideally it would be integrated with their current application
> which is Access 2002 FE / SQL Server 7.0 BE.
> 
> How do I build an encrypted database that I can then lock myself out of
> completely?! Without locking everyone else out too (that I've done
> before).
> 
> Management are willing to spend some money if necessary.
> 
> TIA
> 
> Roz
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 


-- 
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...