Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA-Developer or DBA-Sys admin : which is better combination ?
DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E5F91C0.261548E2_at_exesolutions.com>...
> Paul Drake wrote:
> >
> > well, given my choice between having only "create session" and "create
> > table" vs. having "alter system" and resticted session, I'd rather
> > have a user account that has the DBA role granted to it. one kind of
> > becomes accustomed to having privileges ...
> >
> > but if they only want to grant you "alter user" ... so be it. Good
> > enough for me.
> >
> > Paul
>
> My advice would be to drop the Oracle default roles connect, resource, and DBA as soon as the database is installed.
> Then create new roles with employee-position specific privileges. The default roles as provided by Oracle are not
> intended to reflect real-world needs. And IMO their use reflects little more than a laisez-faire attitude toward
> security.
>
> Daniel Morgan
Daniel,
I was joking.
Sorry for any misunderstanding.
Paul Received on Sun Mar 02 2003 - 12:19:17 CST