Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Table Creation

Table Creation

From: mtwalla <mtwalla_at_bluefishgroup.com>
Date: Thu, 2 May 2002 17:29:00 -0600
Message-ID: <ZWjA8.4696$VQ6.601495@news.uswest.net> 





If I'm creating Tables that all users of an application will typically
access, who should own them? Should the owner be SYS and then create a
Public Synonymn for the the table? Or should there be an application user
who owns all the tables essentially patitioning the application's Databse
Objects? If that is the case, should Synonymns be created on those tables as
well?



Mike
Received on Thu May 02 2002 - 18:29:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US