Home » RDBMS Server » Security » wrap multiple files in a single command
wrap multiple files in a single command [message #123468] Mon, 13 June 2005 11:39 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hai,


We need to wrap all our source code, which includes SP and packages so that no user could modify it.

is it possible to write a shell script which will wrap all the source objects?
There are around 200 files where those sp and packages reside
My qn is how to wrap all thos files in a single command


How do you propose we handle this problem?

very urgent.plz help out.

regards
bala

[Updated on: Tue, 14 June 2005 08:47]

Report message to a moderator

Re: wrap multiple files in a single command [message #123772 is a reply to message #123468] Tue, 14 June 2005 15:38 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can make this any fancy!
Change it to fit your need.

I used a wildcard filter w*.sql.

bash-2.03$ cat wrap_sql
#!/usr/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/9.2.0
export PATH=$ORACLE_HOME/bin:$PATH
ls -lrt /home/oracle/scr/ora/w*.sql | awk '{print $9}' > /tmp/wrap_sql.lst
cat /tmp/wrap_sql.lst | while read file_name
do
echo converting $file_name
wrap iname=$file_name
done
touch /tmp/wrap_sql.lst

bash-2.03$ wrap_sql
converting /home/oracle/scr/ora/w1.sql

PL/SQL Wrapper: Release 9.2.0.4.0- 64bit Production on Tue Jun 14 15:31:27 2005

Copyright (c) Oracle Corporation 1993, 2001.  All Rights Reserved.

Processing /home/oracle/scr/ora/w1.sql to w1.plb
converting /home/oracle/scr/ora/wade.sql

PL/SQL Wrapper: Release 9.2.0.4.0- 64bit Production on Tue Jun 14 15:31:27 2005

Copyright (c) Oracle Corporation 1993, 2001.  All Rights Reserved.

Processing /home/oracle/scr/ora/wade.sql to wade.plb
converting /home/oracle/scr/ora/write_log.sql

PL/SQL Wrapper: Release 9.2.0.4.0- 64bit Production on Tue Jun 14 15:31:27 2005

Copyright (c) Oracle Corporation 1993, 2001.  All Rights Reserved.

Processing /home/oracle/scr/ora/write_log.sql to write_log.plb

[Updated on: Tue, 14 June 2005 15:39]

Report message to a moderator

Previous Topic: how to get program info for session audit
Next Topic: / as sysdba
Goto Forum:
  


Current Time: Mon Aug 03 15:34:49 CDT 2020