Home » SQL & PL/SQL » SQL & PL/SQL » Encrypt a view (oracle, 10g)
Encrypt a view [message #281562] Sun, 18 November 2007 06:21 Go to next message
futi
Messages: 22
Registered: November 2007
Junior Member
hi everybody. i wanna encrypt sys.all_objects view with DBMS_OBFUSCATION_TOOLKIT. and i will write this encrypted data to a file with utl_file.

I can encrypt a text with DES3 in oracle. also i can decrypt, it is ok.

so, how can i encrypt that sys.all_objects view. Row by row or column of row by column of row or exact table by one step? Likely, i can encrypt that table, i will encrypt a row column by column. But is there any tactic, can i encrypt a row or a table/view with one step?

thanx

Re: Encrypt a view [message #281580 is a reply to message #281562] Sun, 18 November 2007 08:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

how can i encrypt that sys.all_objects view

You can't
What is your real need?

Quote:

can i encrypt a row or a table/view with one step?

No.
Once again what is your business need?

Regards
Michel
Re: Encrypt a view [message #281594 is a reply to message #281580] Sun, 18 November 2007 10:03 Go to previous messageGo to next message
futi
Messages: 22
Registered: November 2007
Junior Member
anyway, i will encrypt column by column.
i want to ask another question.

i will use desencrypt in dbms_obfuscation_toolkit. and, likely, the length of input string or data must be multiple of 8. Is it necessary?(it is bad) because i encounter this error consistently :
ORA-28232: invalid input length for obfuscation toolkit
Re: Encrypt a view [message #281595 is a reply to message #281580] Sun, 18 November 2007 10:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

anyway, i will encrypt column by column.

You can't encrypt SYS objects.

Quote:

i will use desencrypt in dbms_obfuscation_toolkit. and, likely, the length of input string or data must be multiple of 8. Is it necessary?

Yes.

Quote:

(it is bad)

No, it is as it works and it is the standard.

Regards
Michel
Re: Encrypt a view [message #281596 is a reply to message #281562] Sun, 18 November 2007 10:16 Go to previous messageGo to next message
futi
Messages: 22
Registered: November 2007
Junior Member
i can encrypt sys objects if i login as a admin. isn't it? because i encrypted with dbms_crypto.

so, you said that it is not bad of length of input must be multiple of 8 bytes..

what can i do? i encrypt a string that length is differ from 8. What can i do? assume, i complete my string to multiple of 8 bytes. When i decrypt it, there is a differ result.
??
help me pls
Re: Encrypt a view [message #281597 is a reply to message #281596] Sun, 18 November 2007 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

can encrypt sys objects if i login as a admin. isn't it?

No.

Quote:

so, you said that it is not bad of length of input must be multiple of 8 bytes..

what can i do? i encrypt a string that length is differ from 8.

Pad it to 8 bytes.

Regards
Michel
Re: Encrypt a view [message #281598 is a reply to message #281597] Sun, 18 November 2007 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can also use one of the padding algorithms provided by dbms_crypto package.

Regards
Michel
Re: Encrypt a view [message #281600 is a reply to message #281562] Sun, 18 November 2007 11:40 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
futi,

I hope you have good backups & proven restoration procdures.
Re: Encrypt a view [message #281612 is a reply to message #281600] Sun, 18 November 2007 13:51 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
anacedent wrote on Sun, 18 November 2007 18:40

futi,

I hope you have good backups & proven restoration procdures.

Wise (and funny) words.
Made a good laugh on this boring sunday evening Smile
Re: Encrypt a view [message #281613 is a reply to message #281562] Sun, 18 November 2007 15:21 Go to previous message
futi
Messages: 22
Registered: November 2007
Junior Member
don't need a worry!
Laughing
Previous Topic: where to get some example database?
Next Topic: Local Index error on Bitmap Index type
Goto Forum:
  


Current Time: Tue Dec 06 04:32:56 CST 2016

Total time taken to generate the page: 0.12710 seconds