Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Chapter 4 General Oracle Security

APP_USERS (which will not happen, since he or she does not have the privilege, but assume the privilege was granted by mistake), he or she will not know the password of APPUSER2. It will be encrypted, and the user does not know the key to decryption.

The other part of the puzzle is how to encrypt the passwords and store them in the table. We will achieve that using the following function.


--   Copyright © 2003 by Rampant TechPress Inc.
--   Free for non-commercial use.
--   For commercial licensing, e-mail
-- *********************************************
create or replace function get_app_password
    p_password  IN varchar2
return varchar2
    v_password    varchar2(2000);
    v_userpass    varchar2(2000);
    errm          varchar2(2000);
    v_passlen     integer;
v_extra       integer;
    v_padlen      integer;
v_key         varchar2(2000) :=

The above text is an excerpt from:

Oracle Privacy Security Auditing

The Final Word on Oracle Security


This is the only authoritative book on Oracle Security, Oracle Privacy, and Oracle Auditing written by two of the world’s leading Oracle Security experts.

This indispensable book is only


 and has an immediate download of working security scripts:


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.