Hi
Thanks for the response guys... There is only one owner and we do not
want to give it DBA rights. Also, the separate tablespaces are for
performance gain, i.e. one set of tables in one tablespace and other
more performance hungry tables in other tablespace. One of the
tablespace would be default for our owner.
Also, Scripts are always run as owner.
-Praveen
Mark D Powell wrote:
> Praveen, Do both set of create table scripts create tables under the
> same or different owners? If the owners are different then either the
> create any table privilege will be needed or the scripts should be ran
> as the owner. If the scripts are ran as the owner and the target
> tablespaces are the default tablespaces for the owners then only the
> owner ID and passwords are necessary to create the tables correctly.
> The owner's ID's should then have the necessary privileges rather than
> you.
>
> If the target db is a production environment why isn't the DBA the
> person applying the scripts?
>
> IMHO -- Mark D Powell --
Received on Tue Oct 18 2005 - 07:04:49 CDT
