| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Database encryption
Hi,
you can use the package I attached to this article. It was posted in this group some months ago.
Thomas Hoof
Patrick Lanphier <planphier_at_psu.edu> schrieb im Beitrag
<37331D10.65CB4AF6_at_psu.edu>...
> What would be a best method to encrypt a couple of columns in the
> database? My thought is to use a PL/SQL package to do the encryption
> and decryption. If you have a package written that would be great.
>
> Patrick Lanphier
> Advanced Information Technologies
> The Pennsylvania State University
>
begin 600 security.sql
M0U)%051%($]2(%)%4$Q!0T4_at_4$%#2T%'12!S96-U<FET>2!I<PT*#0HO*BTM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2T_at_4'5B;&EC#0I-;V1U;&5S("TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2HO#0H-"D953D-424].
M(&5N8W)Y<'0H:6Y?=F%L(%9!4D-(05(R+"!C<GEP=%]M87-K(%9!4D-(05(R M*2!215154DX_at_5D%20TA!4C([#0IP<F%G;6$@<F5S=')I8W1?<F5F97)E;F-E M<RAE;F-R>7!T+"!73D13*3L-"@T*1E5.0U1)3TX@=6YE;F-R>7!T*&EN7W9AM;"!605)#2$%2,BP_at_8W)Y<'1?;6%S:R!605)#2$%2,BD_at_4D5455).(%9!4D-( M05(R.PT*<')A9VUA(')E<W1R:6-T7W)E9F5R96YC97,H=6YE;F-R>7!T+"!7 M3D13*3L-"@T*14Y$.PT*+PT*#0H-"D-214%412!/4B!215!,04-%(%!!0TM! M1T4_at_0D]$62!S96-U<FET>2!)4PT*#0HO*BTM+2TM+2TM+2TM+2TM+2TM+2TM M+2TM+2T_at_4')I=F%T90T*36]D=6QE<R M+2TM+2TM+2TM+2TM+2TM+2TM+2TM M+2TM+2TM+2TM+2TM+2HO#0H-"D953D-424].(&-O;G9B:6XH8S$@8VAA<BD@ M4D5455).($-(05([#0I&54Y#5$E/3B!83U)"24XH8S$@8VAA<BQC,B!C:&%R M*2!215154DX_at_0TA!4CL-"@T*#0HO*@T*?'P@(%!A<F%M971E<G,@.B @(&EN
M7W9A;"!T;R!B92!C<GEP=&5D+@T*?'P@("!C<GEP=%]M87-K('9A;'5E('5S
M960@=&\@8W)Y<'0@:6Y?=F%L#0I\? T*?'P@(%)E='5R;B!686QU97,@.B!E
M;F-R>7!T960@=F%L=64-"GQ\#0I\?" @4'5R<&]S92 Z("!%;F-R>7!T<R!A
M('9A;'5E(&)A<V5D(&]N(&$@<W!E8VEF:65D(&EN<'5T(&UA<VLN#0I\? T*
M?'P@($1E<&5N9&5N8VEE<R Z("!C<GEP=%]M87-K(&UU<W0_at_8F4@/CT@:6X@
M<VEZ92!T;R!I;E]V86P-"GQ\#0I\?" @36]D:69I8V%T:6]N($AI<W1O<GD@
M.B @,C$O,#4O.3_at_L(&-R96%T960N#0HJ+PT*1E5.0U1)3TX_at_96YC<GEP="AI
M;E]V86P_at_5D%20TA!4C(L(&-R>7!T7VUA<VL_at_5D%20TA!4C(I(%)%5%523B!6
M05)#2$%2,B!)4PT*#0I"14=)3_at_T*("TM($UU<W0_at_8F4@9W)E871E<B!O<B!E
M<75A;"!T;R!T:&4@=F%L=64@=&AA="!W:6QL(&)E(&-R>7!T960-"@T*($E&
M($Q%3D=42"AC<GEP=%]M87-K*2 \($Q%3D=42"AI;E]V86PI(%1(14X-"B @
M4D5455).($Y53$P[#0H_at_14Q310T*("!215154DX@*%A/4D))3BAI;E]V86PL
M(&-R>7!T7VUA<VLI*3L@+RH@(D-R>7!T(B J+PT*($5.1"!)1CL-"D5.1#L-
M"@T*#0HO*@T*?'P@(%!A<F%M971E<G,@.B @:6Y?=F%L('1O(&)E('5N96YC
M<GEP=&5D+@T*?'P@(" @8W)Y<'1?;6%S:R!V86QU92!U<V5D('1O('5N96YC
M<GEP="!I;E]V86P-"GQ\#0I\?" @4F5T=7)N(%9A;'5E<R Z('5N+65N8W)Y
M<'1E9"!V86QU90T*?'P-"GQ\("!0=7)P;W-E(#H@(%5N+65N8W)Y<'1E9"!I
M;E]V86P@<')E=FEO=7-L>2!C<GEP=&5D('=I=&@@=&AE(&-R>7!T#0IF=6YC
M=&EO;B H<V5E(&%B;W9E*0T*?'P-"GQ\("!$97!E;F1E;F-I97,@.B @=7-E
M9"!C<GEP="!F=6YC=&EO;B!B969O<F4L(&%N9"!M87-K(&ES('1H92!S86UE
M#0I\? T*?'P@($UO9&EF:6-A=&EO;B!(:7-T;W)Y(#H@(#(Q+S U+SDX#0HJ
M+PT*1E5.0U1)3TX@=6YE;F-R>7!T*&EN7W9A;"!605)#2$%2,BP_at_8W)Y<'1?
M;6%S:R!605)#2$%2,BD_at_4D5455).(%9!4D-(05(R($E3#0H-"D)%1TE.#0H@
M4D5455).*%A/4D))3BAI;E]V86PL(&-R>7!T7VUA<VLI*3L@+RH@(E5N+45N
M8W)Y<'0B("HO#0I%3D0[#0H-"@T*+RH-"GQ\("!087)A;65T97)S(#H@(&,Q
M+"!C:&%R86-T97(@=&\@8F4_at_8V]N=F5R=&5D('1O(&$@8FEN87)Y('9A;'5E
M#0I\?" @4F5T=7)N(%9A;'5E<R Z(&)I;F%R>2!E<75I=B!O9B!C,0T*?'P-
M"GQ\("!0=7)P;W-E(#H@(%5S960_at_9'5R:6YG(&-R>7!T+W5N96YC<GEP= T*
M?'P-"GQ\("!$97!E;F1E;F-I97,@.@T*?'P-"GQ\("!-;V1I9FEC871I;VX@
M2&ES=&]R>2 Z(" R,2\P-2\Y."P_at_8W)E871E9"X-"BHO#0I&54Y#5$E/3B!C
M;VYV8FEN*&,Q(&-H87(I(%)%5%523B!#2$%2($E3#0H-"FQO;W Q(&YU;6)E
M<CL-"G9A;'5E(&YU;6)E<CL-"F1I=FES(&YU;6)E<CL-"G(Q('9A<F-H87(R
M*#,P*3L-"@T*0D5'24X-"B!R,2 Z/2 G)SL-"B!V86QU92 Z/2!!4T-)22AC
M,2D[#0H_at_9&EV:7,@.CT@,3(X.PT*#0H_at_1D]2(&QO;W Q($E.(# N+C<@3$]/
M4 T*#0H@($E&(%1254Y#*'9A;'5E+V1I=FES*2 ](#$@5$A%3_at_T*(" @<C$@
M.CT@<C$@?'P@)S$G.PT*("!%3%-%#0H@("!R,2 Z/2!R,2!\?" G,"<[#0H@
M($5.1"!)1CL-"@T*("!V86QU92 Z/2!V86QU92!M;V0_at_9&EV:7,[#0H@(&1I
M=FES(#H](&1I=FES("\@,CL-"B!%3D0_at_3$]/4#L-"@T*(%)%5%523B!R,3L-
M"D5.1#L-"@T*#0HO*@T*?'P@(%!A<F%M971E<G,@.B @8S$@86YD(&,R#0I\
M?" @4F5T=7)N(%9A;'5E<R Z('AO<G,@8S(@=VET:"!C,0T*?'P-"GQ\("!0
M=7)P;W-E(#H@(%5S960_at_9'5R:6YG(&5N8W)Y<'1I;VX-"GQ\#0I\?" @1&5P
M96YD96YC:65S(#H@(&,Q(&%N9"!C,B!S:6UI;&%R('-I>F5S#0I\? T*?'P@
M($UO9&EF:6-A=&EO;B!(:7-T;W)Y(#H@(#(Q+S U+SDX+"!C<F5A=&5D+@T*
M*B\-"D953D-424].(%A/4D))3BAC,2!C:&%R+&,R(&-H87(I(%)%5%523B!#
M2$%2($E3#0H-"FQO;W Q($Y534)%4CL-"FQO;W Q,2!.54U"15([#0IR,2!6
M05)#2$%2,B_at_X*3L-"G(R(%9!4D-(05(R*#@I.PT*<C,@3E5-0D52.PT*<F5S
M=6QT(%9!4D-(05(R*#0P*3L-"F1I=FES($Y534)%4CL-"@T*0D5'24X-"@T*
M(')E<W5L=" Z/2 G)SL-"@T*($9/4B!L;V]P,2!)3B Q+BYL96YG=&@H8S$I
M($Q/3U -"@T*("!R,2 Z/2!C;VYV8FEN*'-U8G-T<BAC,2QL;V]P,2PQ*2D[
M#0H@('(R(#H](&-O;G9B:6XH<W5B<W1R*&,R+&QO;W Q+#$I*3L-"B @9&EV
M:7,@.CT@,3(X.PT*("!R,R Z/2 P.PT*#0H@($9/4B!L;V]P,3$@24X@,2XN
M."!,3T]0#0H-"B @($E&(%1/7TY534)%4BAS=6)S='(H<C$L;&]O<#$Q+#$I
M*2 K(%1/7TY534)%4BAS=6)S='(H<C(L;&]O<#$Q+#$I*3TQ(%1(14X-"B @
M("!R,R Z/2!R,R K(&1I=FES.PT*(" @14Y$($E&.PT*#0H@("!D:79I<R Z
M/2!D:79I<R O(#([#0H-"B @14Y$($Q/3U [#0H-"B @<F5S=6QT(#H](')E
M<W5L="!\?"!C:'(H<C,I.PT*#0H_at_14Y$($Q/3U [#0H-"B!215154DXH<F5S
C=6QT*3L-"@T*14Y$(%A/4D))3CL-"@T*#0I%3D0[#0HO#0I2
`
 |
 |