PL/SQL - How do you encrypt the function to prevent accessing from users without specific permission. ?

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 195 of 241

How do you encrypt the function to prevent accessing from users without specific permission. ?

Total Answers and Comments: 4

Last Update: May 13, 2008 Asked by: suhasshah2007

Sponsored Links

Best Rated Answer

—

Submitted by: krishnaindia2007

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.

Above answer was rated as good by the following members:
ratna82, sojimonsn

December 11, 2007 12:30:28

rummm

Member Since: December 2007 Contribution: 1

RE: How do you encrypt the function to prevent accessing from users without specific permission. ?

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

January 05, 2008 13:06:13

santhikumard

Member Since: January 2008 Contribution: 1

RE: How do you encrypt the function to prevent accessing from users without specific permission. ?

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

Is this answer useful? Yes | No

January 13, 2008 06:43:02

nitingalande

Member Since: January 2008 Contribution: 4

RE: How do you encrypt the function to prevent accessing from users without specific permission. ?

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

Is this answer useful? Yes | No

May 13, 2008 04:42:33

krishnaindia2007

Member Since: September 2007 Contribution: 854

RE: How do you encrypt the function to prevent accessing from users without specific permission. ?

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank