Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: privilege to a DBA in Oracle
To people who felt the question was dumb!!!.
There is an oracle utility (???), which when installed on the oracle server encrypts schemas, data, etc. and prevent access (read/write) privilege even to SYSDBA...
Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3EDE2007.479E4D46_at_exxesolutions.com>...
> 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.
Received on Thu Jun 05 2003 - 11:58:42 CDT