Re: Schema organization

From: <MHately_at_etech-uk.com>
Date: Thu, 05 Jul 2001 03:05:58 -0700
Message-ID: <F001.0034166D.20010705032024@fatcity.com>

Stephane,

I'm sure they would prefer to operate as the schema owner but to me it's sloppy practice.
You're right; create the objects as DWH and grant the necessary permissions to the application users.
That way only the schema owner has 'admin' rights (create, drop, alter etc.).

If they can't come up with an excellent reason ("it will things easier for us" is NOT an excellent reason) then you should stick to your guns.

Regards,
Mike

|--------+----------------------------->

|        |          paquette stephane  |
|        |          <stephane_paquette@|
|        |          yahoo.com>         |
|        |                             |
|        |          07/05/01 11:40 AM  |
|        |          Please respond to  |
|        |          ORACLE-L           |
|        |                             |


|--------+----------------------------->

  >------------------------------------------------------------|
  |                                                            |
  |       To:     Multiple recipients of list ORACLE-L         |
  |       <ORACLE-L_at_fatcity.com>                               |
  |       cc:     (bcc: Mike Hately/ETECH)                     |
  |       Subject:     Schema organization                     |
  >------------------------------------------------------------|

Hi all,

I'm a fan of having the processing done by a user different than the owner of the data.
Am I alone ?

For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl processing is done by user DWH_PM_TRTMNT and the reporting processing is done by user DWH_BO_TRTMNT.

This way, nobody is connecting as the data's owner. The developpers and Informatica (Powermart) consultant would prefer working directly as DWH.

What do you think ?

Stéphane Paquette
DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant
stephane_paquette_at_yahoo.com

Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: MHately_at_etech-uk.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Jul 05 2001 - 05:05:58 CDT