PL/SQL - how would you hide a table in sql. ie the table can be only visible to its maker.

GeekInterview.com > Tech FAQs > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 6 of 166

how would you hide a table in sql. ie the table can be only visible to its maker.

not known yet

Total Answers and Comments: 6

Last Update: April 15, 2007 Asked by: abhishek

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 27, 2005 01:27:01

sreedhaarreddyb

Member Since: October 2005 Contribution: 1

RE: how would you hide a table in sql. ie the table ca...

Once table is created in your own schema that is only visible to that schema. For others it is not visible.

Is this answer useful? Yes | No

November 07, 2005 06:29:32

shuzghun

RE: how would you hide a table in sql. ie the table ca...

Just don't give any privilege to any other user

its that simple

Is this answer useful? Yes | No

November 12, 2005 10:18:28

M.KUMARAN

RE: how would you hide a table in sql. ie the table ca...

how would you hide a table in sql. ie the table ca...

Is this answer useful? Yes | No

February 06, 2006 06:53:44

chandrika

RE: how would you hide a table in sql. ie the table ca...

by using a wrap command

Is this answer useful? Yes | No

March 27, 2007 04:00:49

hindol_saha

Member Since: March 2007 Contribution: 15

RE: how would you hide a table in sql. ie the table ca...

how it is possible please describe it.

Is this answer useful? Yes | No

April 15, 2007 14:57:52

madhug56

Member Since: November 2005 Contribution: 13

RE: how would you hide a table in sql. ie the table ca...

The wrap utility takes a readable ASCII text file as input and converts it to a file containing byte code. The result is that the DBA developers or anyone with database access cannot view the source code in any readable format.

The command line options for wrap are:

wrap iname [file] oname [file]

· iname – The name of the unencrypted PL/SQL file to be used as input (your source file).

· oname – The name of the output file. This file will be encrypted.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank