Re: Access to V$ views

Ed wrote:

> Hi,
>
> My DBA is very protective about everything. For example, recently he
> threatened to take CREATE TABLE privilege away from me as I had
> committed the heinous crime (on a development machine) of creating a
> table without the storage clause! By the way, I have over 10 years
> experience developing in Oracle (I remember V5), and I used to be a
> DBA.
>
> How can I him to give me access to the V$ views? i.e. What are the
> possible reasons for and against granting access to these views to
> developers?
>
> I would be grateful for a few suggestions, as this my prevent me
> killing him, and I wouldn't want to deprive my children of their
> father.
>
> Thanks,
>
> Ed

Please don't take this the wrong way. But if I had someone claiming 10 years of Oracle beginning with version 5, that had to ask for help in coming up with reasons why they need access to V$ views I would take away their create table privilege too.

The reason for denying it is paranoia ... a developer might figure out that they don't know what they are doing. They are insecure ... they think you might try to do what they perceive to be their job.

The reason for granting access is that no developer can get within 100 meters of competence without them. Likely you don't have the ability to kill development sessions either. Something I consider a near criminal act.

Daniel Morgan Received on Tue May 07 2002 - 15:08:50 CDT