Re: Limiting Privileges....

Dear Sybrand,

I feel that I am responsible for the maintenance. (for example, I wish not to provide only 10% of the access to a DBA...). The denial of certain privilege is not with the data (itself), but may be for a view/table. Brian...Sorry for the repeat post (When I checked after 8 hours I thought my message did not get posted)....

I know that a DBA will (should) have access to all objects in a database. But is it possible to demote the DBA to the level of a user. Please advise.

Thanks
Nathan

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<5cnpdv4beqbe2q75vgbhfo0t3ade4gjttn_at_4ax.com>...
> On 3 Jun 2003 10:15:05 -0700, nathan_970365_at_yahoo.com (Nathan) wrote:
>
> >I have created some objects (primarily tables and views) using Oracle
> >8i. Now, after transferring the database to an Oracle server 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 (not the data in my database) to a DBA.
> >
> >If DBA must have all the access rights, then is there any possibility
> >by which I can bypass the DBA and provide an access to someone like
> >Superuser?
> >
> >Thanks in advance for all your help.
> >
> >Bye
> >Nathan
>
>
> If you don't want to have a customers DBA have access, you shouldn't
> sell your application.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Jun 03 2003 - 18:27:08 CDT