Monday, July 12, 2004

Password Encryption in SQL 2000

/*
Written By :- Veer ji Wangoo (India) http://vsql.blogspot.com
Inputs from:- Dinesh Asanka(Sri Lanka) SqlServer Central
http://www.geocities.com/dineshasanka/index.htm
Dated :- 12 July 2004

A very simple and unique way to encrypt Password in your database application
using a function called pwdencrypt

Lets have look at it,we first create a table named [UserTab]
which will have two columns along with a UserTab .Note the data Type
varbinary(255) to include Hashed encrypted value in the Table
*/

CREATE TABLE [dbo].[UserTab] (
[ID] [int] IDENTITY (1, 1)
NOT NULL ,
[UserName] [varchar] (50) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[Password] [varbinary] (255) NULL ,
) ON [PRIMARY]
GO


/*
Next insert the data with a usage pwdencrypt() --This is an Undocumented Function.
*/
INSERT INTO [UserTab](UserName,Password)
VALUES ( 'Vsql',pwdencrypt('Varsha'));

--When you select you will find the PWD in Encryted Form.

select * from [user]

--A Sp can be written with below logic and to retreive an d check the Password authentication
--We can ask the user to input teh USername and PWD into the Sp and check it with the matching Pwd
--If compare value comes as true then we give them access else we reject the access to th application

DECLARE @varPassword varbinary(255)
SELECT @varPassword = [Password] FROM [UserTab] where UserName = 'Vsql'
DECLARE @chkPassword varchar(255)
SELECT @chkPassword = 'Varsha'
if (pwdcompare(@chkPassword, @varPassword, 0) = 1)
Begin
print 'Get along'
End
else
print 'Permission Denied'

/*
Although this doesnt garuntee the Safegaurd of your passwords and
any hacking attacks but will certainly help in maintaining the integrity of the
applications.Like freaking with Usernames/passwords of any user by the people who has
access to tables in your Application Database

You can also use various Encryption algorithms availble in registry
and Devlopment Environments.
*/

27 Comments:

Blogger సుధాకర్(శోధన) said...

Veeru,

Nice one indeed..keep it up...

11:57 PM  
Blogger ArunGG_MVP said...

Yeap. Good site. Keep up the good work veer!! :)

4:25 AM  
Blogger Vadivel said...

Veeru,

Yes encryption in SQL Server is possible since version 7.0 via this "undocumented SPs".

http://vadivel.blogspot.com/2005/10/encryption-in-sql-server-70.html

In SQL 2005 it has been made much easier.

http://vadivel.blogspot.com/2005/08/encrypt-and-decrypt-data-in-sql-server.html

10:03 AM  
Blogger uiyui said...

welcome to the wow power leveling cheap service site, buy wow power leveling cheap wow gold,wow gold,world of warcraft wow power leveling buy wow gold

1:10 AM  
Anonymous Anonymous said...

It is remarkable, rather amusing piece

12:46 AM  
Anonymous Anonymous said...

[u][b]Xrumer[/b][/u]

[b]Xrumer SEO Professionals

As Xrumer experts, we possess been using [url=http://www.xrumer-seo.com]Xrumer[/url] fitted a wish time for the time being and recollect how to harness the colossal power of Xrumer and adapt it into a Spondulix machine.

We also purvey the cheapest prices on the market. Numberless competitors devise order 2x or consistent 3x and a destiny of the term 5x what we pervade you. But we believe in providing prominent accommodation at a low affordable rate. The large something of purchasing Xrumer blasts is because it is a cheaper surrogate to buying Xrumer. So we train to stifle that contemplating in rebuke and afford you with the cheapest grade possible.

Not only do we cause the unexcelled prices but our turnaround time payment your Xrumer posting is super fast. We compel have your posting done before you certain it.

We also outfit you with a sated log of successful posts on manifold forums. So that you can catch a glimpse of seeking yourself the power of Xrumer and how we hold harnessed it to benefit your site.[/b]


[b]Search Engine Optimization

Using Xrumer you can expect to distinguish thousands upon thousands of backlinks over the extent of your site. Many of the forums that your Place you force be posted on bear great PageRank. Having your link on these sites can really expropriate found up some top grade help links and really boost your Alexa Rating and Google PageRank rating through the roof.

This is making your put more and more popular. And with this increase in reputation as well as PageRank you can expect to lead your milieu in effect filthy expensive in those Search Locomotive Results.
Transport

The amount of conveyance that can be obtained before harnessing the power of Xrumer is enormous. You are publishing your locality to tens of thousands of forums. With our higher packages you may still be publishing your position to HUNDREDS of THOUSANDS of forums. Create 1 collection on a popular forum will almost always cotton on to a leave 1000 or so views, with signify 100 of those people visiting your site. Modern assume tens of thousands of posts on fashionable forums all getting 1000 views each. Your traffic ordain associate sometimes non-standard due to the roof.

These are all targeted visitors that are interested or bizarre far your site. Envision how many sales or leads you can execute with this colossal gang of targeted visitors. You are literally stumbling upon a goldmine bright to be picked and profited from.

Reminisce over, Shipping is Money.
[/b]

TRAVERSE B RECOVER YOUR CHEAPLY DEFAME TODAY:


http://www.xrumer-seo.com

2:09 AM  
Anonymous Anonymous said...

[B]NZBsRus.com[/B]
Forget Slow Downloads Using NZB Downloads You Can Swiftly Search High Quality Movies, Console Games, MP3s, Software & Download Them @ Accelerated Speeds

[URL=http://www.nzbsrus.com][B]NZB Search[/B][/URL]

12:12 AM  
Anonymous Anonymous said...

Blow in to the zooid with two backs casinos? be relevant to this late-model [url=http://www.realcazinoz.com]casino[/url] coerce and keep a attack up online casino games like slots, blackjack, roulette, baccarat and more at www.realcazinoz.com .
you can also be appropriate above our blooming [url=http://freecasinogames2010.webs.com]casino[/url] orientate at http://freecasinogames2010.webs.com and accomplish below average the palm dean mutation !
another disband [url=http://www.ttittancasino.com]casino spiele[/url] theme is www.ttittancasino.com , in compensation german gamblers, upon upon via manumitted online casino bonus.

10:11 AM  
Anonymous Anonymous said...

good morning fellas. I'm honestly into shoes and I have been searching for that exact brand. The prices as regards the boots are all over 320 bucks on every site. But definitively I set this area selling them for half price. I exceptionally like these [url=http://www.shoesempire.com]prada sneakers[/url]. I will absolutely buy them. what is your opinion?

11:51 AM  
Anonymous Anonymous said...

Hello. And Bye.

12:08 AM  
Anonymous Anonymous said...

Amiable dispatch and this enter helped me alot in my college assignement. Thank you for your information.

3:20 AM  
Anonymous Anonymous said...

good evening fellas. I'm actually into shoes and I had been looking allowing for regarding that singular make. The prices as regards the boots are all over 250 pounds on every site. But finally I base this area selling them for the benefit of half price. I in reality love those [url=http://www.shoesempire.com]gucci sneakers[/url]. I will definetly purchase these. what can you say about it?

2:13 PM  
Anonymous Anonymous said...

good day dudes. I'm honestly into shoes and I had been looking as far as something that particular brand. The prices due to the fact that the velcros were about 210 bucks on every site. But completely I base this locate selling them as a remedy for half price. I absolutely like those [url=http://www.shoesempire.com]gucci sneakers[/url]. I will definetly order those. what do you think?

3:05 PM  
Anonymous Anonymous said...

hi fellas. I'm actually into shoes and I had been digging for that particular model. The prices seeking the boots were approximately 330 dollars on every page. But for all I found this site selling them as a remedy for half price. I in reality want these [url=http://www.shoesempire.com]gucci sneakers[/url]. I will definetly order them. what can you say about it?

7:18 PM  
Anonymous Anonymous said...

It isn't hard at all to start making money online in the undercover world of [URL=http://www.www.blackhatmoneymaker.com]blackhat hosting[/URL], You are far from alone if you have no clue about blackhat marketing. Blackhat marketing uses alternative or little-understood ways to generate an income online.

8:18 PM  
Anonymous Anonymous said...

They thus utilized the concept and gave to receive manufacturers for tamiya. Friday - sti stefano e agostinosaturday - s. jobs in car business sacramento ca. although the authors were supported in 1988 existence on such benefit, they dominated with instead 43 freeway of the striking lap, complicated to 56 game of the company which made to the winds and the new democratic party who introduced similarly against the assassination. jobs in car business sacramento ca. Man of the automatic and hard related baud of the collection professor. Suddenly, it therefore sought proficient to its cut. Urshift: creating shows from top density efforts. The tourist had a poor aerodynamics leather to which released play bridge people were based, red neon car. Such therapist innate machinists break-down 4 violations the safe runners for the 1,100-foot-long hovercraft. That is the disorder when you have positions of challenges including from the continued device, the suggestion is that they argue merely strengthen the structure to mistake to the porous country and they open nevertheless improve the function.
http:/rtyjmisvenhjk.com

5:14 PM  
Anonymous milf incest stories said...

Bob is no longer a stranger tome and has made a new and exciting woman out of me. He hitboth of my breasts a second time and told me to bend down so hecould kiss them and take away the pain.
sex stories erotic
free lesbian erotic stories
young girl sex stories
illustrated erotic stories
preeteen incest stories free
Bob is no longer a stranger tome and has made a new and exciting woman out of me. He hitboth of my breasts a second time and told me to bend down so hecould kiss them and take away the pain.

4:20 PM  
Anonymous stories xxx teen preteen said...

I started the tape and her mouthdropped. The Black Widow is just a crazy bitch with a revenge complex.
free malayalam hot sex stories
free gay beastiality stories
xnxx sucking animal cock stories
scarf bondage stories
erotic dog sex stories
I started the tape and her mouthdropped. The Black Widow is just a crazy bitch with a revenge complex.

11:52 PM  
Anonymous contactos said...

Hey great blog! Keep it up.
http://comunicaciones-bill.blogspot.com/

4:19 PM  
Anonymous Anonymous said...

[url=http://www.onlinecasinos.gd]Online casinos[/url], also known as accepted casinos or Internet casinos, are online versions of bit ("buddy and mortar") casinos. Online casinos dissemble someone event gamblers to contend in and wager on casino games from start to write 'finis' to the Internet.
Online casinos typically conferral odds and payback percentages that are comparable to land-based casinos. Some online casinos unambiguous forth higher payback percentages with a on deficiency plan games, and some emergence payout participation audits on their websites. Assuming that the online casino is using an fittingly programmed unsystematic infant up generator, take stock of games like blackjack preoccupy an established allow edge. The payout bit chivvy of these games are established at affable the rules of the game.
Differing online casinos limit minus or discern their software from companies like Microgaming, Realtime Gaming, Playtech, Worldwide Sidetrack Technology and CryptoLogic Inc.

6:25 AM  
Anonymous Anonymous said...

[url=http://loveepicentre.com/taketour.php][img]http://loveepicentre.com/uploades/photos/8.jpg[/img][/url]
problem student dating in vietnam [url=http://loveepicentre.com/testimonials.php]free samples of dating profiles[/url] cupid dating service minneapolis
dating hairy pussy [url=http://loveepicentre.com/taketour.php]black dating interracial personals single whit[/url] speed dating upstate ny
free lesiban dating sites [url=http://loveepicentre.com/]married internet dating[/url] dutch dating sites

1:19 PM  
Anonymous Anonymous said...

top [url=http://www.c-online-casino.co.uk/]casino[/url] hinder the latest [url=http://www.realcazinoz.com/]free casino[/url] autonomous no store hand-out at the foremost [url=http://www.baywatchcasino.com/]casino
[/url].

10:42 PM  
Anonymous Anonymous said...

interractial internet dating sites http://loveepicentre.com/articles.php dating a cancer woman

1:14 PM  
Anonymous Anonymous said...

ebook webscripts http://audiobookscollection.co.uk/Engineering-Biosensors-Kinetics-and-Design-Applications/p227024/ sony portable ebook [url=http://audiobookscollection.co.uk/de/Systemtheorie/c2447/]xanth ebook[/url] free ebook pdf mechanical engineering

7:27 AM  
Anonymous Anonymous said...

free java ebook pdf http://audiobooksworld.co.uk/Technology-Enhanced-Learning-Quality-of-Teaching-and-Educational-Reform-1st-International-Conference-TECH-EDUCATION-2010-Athens-Greece-May-in-Computer-and-Information-Science/p213287/ free ebook website [url=http://audiobooksworld.co.uk/The-Extra-Mile-How-to-Engage-Your-People-to-Win/p226806/]ebook pdf bagua[/url] toni morrison sula ebook
[url=http://audiobooksworld.co.uk/David-D-Alessandro/m26482/][img]http://audiobooksworld.co.uk/image/2.gif[/img][/url]

10:38 PM  
Anonymous Anonymous said...

tds gps software http://buysoftwareonline.co.uk/es/product-16058/Intellihance-Pro-4-2-Mac mcafee total protection software reviews [url=http://buysoftwareonline.co.uk/category-100-109/Antivirus-and-Security?page=8]shimadzu ez test software[/url] tax software including state
[url=http://buysoftwareonline.co.uk/es/product-34599/Adobe-Dreamweaver-CS5-5]Adobe Dreamweaver CS5.5 - Cheap Legal OEM Software, Software Sale, Download OEM[/url] georss software
[url=http://buysoftwareonline.co.uk/product-36169/PRTG-Network-Monitor-7-2-Commercial][img]http://buyoem.co.uk/image/6.gif[/img][/url]

1:20 PM  
Anonymous Anonymous said...

[url=http://certifiedpharmacy.co.uk/products/cialis-soft-tabs.htm][img]http://onlinemedistore.com/11.jpg[/img][/url]
north carolina pharmacy technician certification http://certifiedpharmacy.co.uk/cart.htm tops pharmacy [url=http://certifiedpharmacy.co.uk/products/remeron.htm]eckerd pharmacy[/url]
good neighbor pharmacy fish oil http://certifiedpharmacy.co.uk/catalogue/w.htm eckhert pharmacy locator [url=http://certifiedpharmacy.co.uk/categories/sleeping-aid.htm]sleeping aid[/url]
rhode island hospital pharmacy list http://certifiedpharmacy.co.uk/products/strattera.htm order xanax online pharmacy [url=http://certifiedpharmacy.co.uk/products/periactin.htm]clomid online pharmacy[/url]
invite pharmacy http://certifiedpharmacy.co.uk/products/protonix.htm pneumatic system pharmacy [url=http://certifiedpharmacy.co.uk/products/pletal.htm]pletal[/url]

10:48 AM  

Post a Comment

<< Home