Re: Administration.
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Tue, 2 Jun 2009 06:22:52 -0700 (PDT)
Message-ID: <4240e8ca-70ff-4a50-9ba7-9047d384410b_at_s21g2000vbb.googlegroups.com>
On Jun 1, 4:15 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jun 1, 6:03 am, "Markus Gronotte" <maqq..._at_gmx.de> wrote:
>
> > I do this Code as System:
>
> Besides what the others said, you probably don't want to use system
> for tables you create. It's not the critical error of earlier
> versions, but still considered bad form. If you need a controlling
> schema, make one. Leave system and its tablespace alone, except for
> supported DBA use.
>
> jg
> --
> _at_home.com is bogus.
> Black lineshttp://www.washingtonpost.com/wp-dyn/content/article/2009/05/30/AR200...
Date: Tue, 2 Jun 2009 06:22:52 -0700 (PDT)
Message-ID: <4240e8ca-70ff-4a50-9ba7-9047d384410b_at_s21g2000vbb.googlegroups.com>
On Jun 1, 4:15 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jun 1, 6:03 am, "Markus Gronotte" <maqq..._at_gmx.de> wrote:
>
> > I do this Code as System:
>
> Besides what the others said, you probably don't want to use system
> for tables you create. It's not the critical error of earlier
> versions, but still considered bad form. If you need a controlling
> schema, make one. Leave system and its tablespace alone, except for
> supported DBA use.
>
> jg
> --
> _at_home.com is bogus.
> Black lineshttp://www.washingtonpost.com/wp-dyn/content/article/2009/05/30/AR200...
Joel is correct. You really should create a new username, grant it the desired privileges (perhaps DBA), and use it for your testing, study, and maybe even development.
IMHO -- Mark D Powell -- Received on Tue Jun 02 2009 - 08:22:52 CDT