Re: privilege to a DBA in Oracle

Dear All,

Thanks a lot for all your valuable suggestions...I can understand that I need to provide complete access to a DBA..

Let me rephrase my question...I have two products (each containing 15 tables) and my database has 30 tables. But, if one of my customer purchases only one product, I wish to provide access only to 15 tables and the for the rest, I wish to revoke the read/write access. Can any one guide me how to approach the problem (without developing two different databases..)...

Once again, Thanks in Advance..

Sincerely,
Nathan

Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3EDCC47D.A1FAABBF_at_exxesolutions.com>...
> Nathan wrote:
>
> > I have created some objects (primarily tables and views) using Oracle
> > 8i. Now, after transferring the database to an Oracle server (for
> > example, say at a customer site), is it possible to control the access
> > privilege of my customer's DBA? To put it in a nutshell, is there a
> > way to provide partial access of my objects to a DBA.
> >
> > Thanks in advance for your help.
> >
> > Sincerely,
> > Nathan
>
> Depends on what you mean.
>
> You can not deny access to the objects themselves but you can deny access
> to source code by wrapping it and you can deny access to data with
> encryption.
Received on Tue Jun 03 2003 - 22:08:47 CDT