Re: Schema Concepts 101 [newbie]

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 01 May 1999 02:11:05 GMT
Message-ID: <37365a5b.9546516@netnews.worldnet.att.net>

On Fri, 30 Apr 1999 14:27:49 -0500, "David Thom" <davidt_at_npsinc.com> wrote:

>>Normally most DBA's work with Oracle usernames and set up application
>owners, say A,
>
>Would you define A as a DBA and do your development work while connected as
>A?

Hope you don't mind my jumping in. Normally, schema owners are not used for development. Say I had an application named PAYROLL. I might create a PAYROLL user, and create all the tables under that one user. Developers would get their own user-ids, I would grant those IDs access to the PAYROLL schema, and the developers would each work with their own IDs.

Jonathan Received on Fri Apr 30 1999 - 21:11:05 CDT