Re: Access to V$ views

Im a developer and I find access to the v$views and the rest of the data dictionary incredibly useful. Anyone who says they are not are either lousy developers or obnoxious overly controlling DBAs. Though I am hardly what people call senior, I find that the DBA and developer roles can often overlap and its important that if you are one or the other to atleast have some basic facilities with each.

Your DBA sounds like a jerk. Go over the fools head to the management and demand access. Who cares what you do on a development server? We all do all kinds of crap on development boxes. I experiment all the time on them.

j.w.vandijk.removethis_at_hetnet.nl (Jaap W. van Dijk) wrote in message news:<3cd82243.2010251_at_news.jaapwvandijk.myweb.nl>...
> I can imagine, with your background, you must feel blind without
> access to the v$ views. But do you *really* need them as a developer?
>
> My strategy is: in the development environment the developers are
> welcome to muck up the database as much as they like, but as soon as
> things pass to system and acceptance test environment the database is
> my ballpark, and the only one that makes changes to it is me or my dba
> colleagues, because I am responsible for the reliability of the test
> results as far as the schema is concerned.
>
> Jaap.
>
> On 7 May 2002 05:17:38 -0700, esicl_at_aol.com (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
Received on Tue May 07 2002 - 17:35:14 CDT