Re: Hiding data model

From: Sriram Kumar <>
Date: Wed, 28 Jan 2015 18:40:25 +0530
Message-ID: <>

Hello Harmandeep,

Hiding data model could not be implemented through VPD. I knew of a product which used to have place holder names instead of real tables and columns so that outsiders can't understand the table names or column names


create table emp
emp_id number,
ename varchar2(100),
hire_date date,
dept_id number)

would have a table structure similar to

create table T001
T1 number,
T2 varchar2(100),
T3 date,
T4 number)

biggest problem was training the newer folks in the development team to understand them and over a period it overweighs the benefit of hiding

hope it helps

best regards


On Wed, Jan 28, 2015 at 5:09 PM, Harmandeep Singh <> wrote:

> Hi Experts,
> We are having data model for our product, which we do not want to expose
> to our customers. That is we want even the DBA of customer with sys
> privileges should not understand /access the data model( like table
> definitions, columns ).
> I am aware of options like VPD, which is data level security feature as
> per my understanding.
> Please let me know your thoughts
> Thanks,
> Harmandeep Singh

Received on Wed Jan 28 2015 - 14:10:25 CET

Original text of this message