Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

Author
 Message
 Posted Friday, March 14, 2008 10:17 AM
 SSChasing Mays Group: General Forum Members Last Login: Friday, September 20, 2013 4:23 AM Points: 620, Visits: 1,071
 I am attempting to create a backend database that is to accessed by a front end web site. I have created a single table in my sql db 'dbo.Users'. One of the fields contains the users password. Currently it is stored in plain text. In access I know how to mask this but how is it achieved in SQL?Many Thanks,Phil. -------------------------------------------------------------------------------------A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge." Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... ' Tommy Cooper
Post #469522
 Posted Friday, March 14, 2008 10:39 AM
 SSChasing Mays Group: General Forum Members Last Login: Tuesday, August 20, 2013 2:16 PM Points: 655, Visits: 6,099
 Check out Encryption:Columns in SQL Server BOLDAB
Post #469535
 Posted Friday, March 14, 2008 1:38 PM
 SSChasing Mays Group: General Forum Members Last Login: Friday, September 20, 2013 4:23 AM Points: 620, Visits: 1,071
 Thanks I will have a read.Phil -------------------------------------------------------------------------------------A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge." Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... ' Tommy Cooper
Post #469670
 Posted Saturday, March 15, 2008 7:09 AM
 SSChasing Mays Group: General Forum Members Last Login: Friday, September 20, 2013 4:23 AM Points: 620, Visits: 1,071
 Back again. I am running SQL 2005 on a XP Pro machine. Here is what I did:create master key encryption by password = 'Pufd&s@))%';create certificate cert_sk_admin with subject = 'Certificate for accessing symmetric keys - for use by admin';create certificate cert_sk_charles with subject = 'Certificate for accessing symmetric keys - for use by Charles';create symmetric key sk_users with algorithm = aes_192 encryption by certificate cert_sk_admin;The above command generates an error:Msg 15314, Level 16, State 1, Line 1Either no algorithm has been specified or the bitlength and the algorithm specified for the key are not available in this installation of Windows.Any Ideas?Thanks,Phil. -------------------------------------------------------------------------------------A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge." Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... ' Tommy Cooper
Post #469810
 Posted Saturday, March 15, 2008 9:19 AM
 SSC-Dedicated Group: Administrators Last Login: Yesterday @ 2:20 PM Points: 32,291, Visits: 14,547
 I don't believe that AES is available in XP.No one is likely to crack them. I'd use one of the shorter and quicker algorithms like RSA for the asymmetric key. Follow me on Twitter: @way0utwestForum Etiquette: How to post data/code on a forum to get the best help
Post #469834
 Posted Saturday, March 15, 2008 10:22 AM
 SSChasing Mays Group: General Forum Members Last Login: Friday, September 20, 2013 4:23 AM Points: 620, Visits: 1,071
 Thanks Steve, I will have a read up on asymmetric keys.Phil -------------------------------------------------------------------------------------A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge." Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... ' Tommy Cooper
Post #469861

 Permissions