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

Not known yet
  • Interview Candidate
  • 17
  • 3541

Showing Answers 1 - 17 of 17 Answers

shuzghun

  • Nov 7th, 2005
 

Just don't give any privilege  to any other user

its that simple

  Was this answer useful?  Yes

M.KUMARAN

  • Nov 12th, 2005
 

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

  Was this answer useful?  Yes

chandrika

  • Feb 6th, 2006
 

by using a wrap command

  Was this answer useful?  Yes

madhug56

  • Apr 15th, 2007
 

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. 

  Was this answer useful?  Yes

pravelu

  • Apr 23rd, 2010
 

It can be done using role grants. Grant view or debug privileges to only the set of users who can see these tables. The other users who are not granted the privilege cannot view this table. Every single user is a Schema in Oracle.

It is by default, that the table cannot be seen by others.

  Was this answer useful?  Yes

ankurlibra

  • Sep 26th, 2010
 

We are misunderstanding the question and I assume that Abhishek want to say that "How we can hide a table info from user?".

To hide table info or as per question make it invisible to other user. A table owner can make a synonym with different name (eg: ABC) on user table (eg: XYZ) and then provide privilege on the synonym (ABC) to other users.
Now other users will not come to know that which table in original they are using.

Hope that will help you.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions