Re: PeopleSoft SQR Development Question -Reply

[Albert Howard <starbukk@concentric.net>]

In an implementation environment you are shooting yourself in the foot if
you do not allow developers acccess to the sysadm.  SQR's will normally be
run by Process Scheduler in production, so they can be developed pointing
to sysadm.  But this of course means that the developers need sysadm
access. Without that, you will just take two or three times longer to get
things done.

Once you are in a production environment, you can lock down production, but
developers need a development database where they have full access.  Any
less will cause delays.

I never create/drop tables in SQR.  Always define them outside the program,
usually in Application Designer.

You asked about the right forum.  A good place for questions like this is
http://www.peoplesoftfans.com. THey have a discussion group there thats
pretty good.

>>>> Mike Fulce <m.fulce@USM.EDU> 10/02/98 04:32pm >>>
>Maybe this is more for DBA's (specifically ORACLE) than developers.
>(However, I'm not looking for philosophy, just practicality)
>
>I'd just like to hear how some of your shops manage the SQR development
>environment with PeopleSoft, ie:
>
>Do you allow developer's to run SQR's outside of PeopleSoft as user sysadm?
>
>If not, then how do you handle table reference coding in SQR's? Do you
>create synonymns for all of the PS tables or do you force the developers to
>code the schema name?
>
>What privileges do you give your developer's in the development database?
>Full or limited? If limited, please specify.
>
>Do you allow custom SQR's to build/drop temporary tables dynamically or do
>they use truncate on existing tables that the DBA created.
>
>I would like to have a loose development environment by giving SQR
>developers privileges to be able to connect to the development database
>outside of PeopleSoft to do queries or to run SQR's directly and to be able
>to do some DDL. However, since we are new to PeopleSoft and Oracle/SQR, our
>developer's are inexperienced. So I really don't want them connecting with
>the privileges of user sysadm outside of PeopleSoft.
>
>I'd appreciate any responses.
>___________________________________________________________________________
___
>Mike Fulce                    __   Oracle Database Administrator I
>OTR-Admin. Resources      ___/ /__ University of Southern Mississippi
>m.fulce@usm.edu          /__  ___/ Voice:(601) 266-6102 Fax:(601) 266-6881
>207 Forrest County Hall    / /     Box 5171, Hattiesburg, MS 39406
>                          / /      http://ocean.otr.usm.edu/~rmfulce
>                          ^^
>