Re: Schema Naming Standards

From: Dave Morgan <>
Date: Thu, 28 May 2015 10:48:51 -0600
Message-ID: <>

I agree with the comment "Don't change unless there is a defined need"

I like to implement the following

SCHEMA_DO	DO = data owner, owns the objects, DBA only access
SCHEMA_DE	DE = data entry, has read, insert, update privs
SCHEMA_RO	RO = read only, has read privs

There are variations on this of course _WEB for a web server, _RPT for off hours report jobs, .....



Dave Morgan
Senior Consultant, 1001111 Alberta Limited
403 399 2442
-- Received on Thu May 28 2015 - 18:48:51 CEST

Original text of this message