Home » SQL & PL/SQL » SQL & PL/SQL » How to Create a Password? (Oracle 10g)
icon5.gif  How to Create a Password? [message #383318] Wed, 28 January 2009 04:50 Go to next message
astraleader
Messages: 2
Registered: January 2009
Location: Germany
Junior Member
Hi @ all,
i'm searching for an easy way to create a passwordfield, like it is possible in access.
When someone is looking into the table from access or tora etc. over odbc he should only see **** or something else.

The only thing i found is this:
CREATE TABLE mitarbeiter(
ma_nr NUMBER,
name VARCHAR2(30),
gehaltsgruppe VARCHAR2(9) ENCRYPT USING 'AES128');


But i dont know, if this is THE solution.

Sorry for the bad english, im from Germany.
Greets
Simon
Re: How to Create a Password? [message #383319 is a reply to message #383318] Wed, 28 January 2009 05:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Have a look at dbms_crypto package.

Regards
Michel
Re: How to Create a Password? [message #383352 is a reply to message #383318] Wed, 28 January 2009 07:22 Go to previous message
astraleader
Messages: 2
Registered: January 2009
Location: Germany
Junior Member
ok thanks, i will try!
Previous Topic: Compare records
Next Topic: creating User & assign Role
Goto Forum:
  


Current Time: Sat Dec 07 04:49:07 CST 2024