Re: privilege to a DBA in Oracle

Liz R wrote:

> 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.

Not as dumb as it sounds. Create a procedure to build out schema objects based on a small procedure that takes as input a license key. A little WRAP and a little OBFUSCATION and you're in business.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)