Re: privilege to a DBA in Oracle

Dumb question, why are you sending the 15 tables they haven't paid for?

Liz

"Nathan" <nathan_970365_at_yahoo.com> wrote in message news:989d0dbe.0306031908.56bc4ce_at_posting.google.com...
> 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 Wed Jun 04 2003 - 11:09:29 CDT