Schema management

Hello,

Is there any accepted best practice regarding schema management? We are a small datawarehouse experiencing growing pains; currently, we use a different owner account for each application area, but applications are frequently crossing schema boundaries and using tables from several schemas. The suggestion has been made to use a single schema which would own everything, and control privileges entirely thru roles. This would simplify development, but I wonder what the disadvantages would be (other than the security concern over having everything in one schema; is this something to worry about?). Using Oracle 8.1.6 on Solaris with Cognos tools.

Thanks to any responders.
beckerb_at_dgabby.mfldclin.edu Received on Wed Oct 18 2000 - 08:18:00 CDT