Re: Schema Naming Standards

From: Dave Morgan <oracle_at_1001111.com>
Date: Thu, 28 May 2015 10:48:51 -0600
Message-ID: <556746F3.30505_at_1001111.com>

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

--

Dave Morgan
Senior Consultant, 1001111 Alberta Limited dave.morgan_at_1001111.com
403 399 2442
--

http://www.freelists.org/webpage/oracle-l Received on Thu May 28 2015 - 18:48:51 CEST