rummm

 Profile Answers by rummm 

• Dec 11th, 2007

 

I think all we can do is check whether the user has the privileges as the first step in the function...
any othr way??

santhikumard

 Profile Answers by santhikumard 

• Jan 5th, 2008

 

I think you can use wrap utility encrypt the function / procedure program units

for example create a function store it as xx.sql file

c:oracle> wrap iname=<full path>xx.sql


This process will result xx.plb file which is encrypted

Hope this helps

SK

nitingalande

 Profile Answers by nitingalande 

• Jan 13th, 2008

 

Function can be encrypted using Oracle Wrap utility. this will prevent accessing from users without permission

krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 13th, 2008

 

Using wrap utility we can encrypt source code of a function  to byte code (Not a readable format).  Becareful there is no  decrypt utility to convert  source code back to ascii format. 

if you aim is  just  to prevent function accessing from users do not give privelege on that function to other users.