Uniqueness of Passwords and Usenames in tables

From: Jonny B <no-mail_at_no-mail.spammers>
Date: Wed, 04 Dec 2002 12:43:22 +0000
Message-ID: <gotruusuv9eqs9d2fljni703pf0pbaqt94@4ax.com>

I'm attempting to set up a table of passwords and usernames but I obviously dont want confilcting usernames or passwords, therefore I need some sort of uniquness. How might I go about this? Any ideas?

create sequence autonum_password
START WITH 1
INCREMENT BY 1
NOMAXVALUE; CREATE TABLE pass
(pass_id number(10) primary key,

password varchar2(25) CONSTRAINT nn_password NOT NULL CONSTRAINT
u_password  CHECK( password = UPPER(password)), 
username varchar2(30) CONSTRAINT nn_username NOT NULL CONSTRAINT

u_username CHECK( username = UPPER(username)), type varchar2(30) CONSTRAINT nn_type NOT NULL CONSTRAINT u_type CHECK( type = UPPER(type)));

I'd like to make a combination of the password AND username unique... Just don't know how. Received on Wed Dec 04 2002 - 06:43:22 CST