Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA Responsibilities... who owns the database?
No, it really isn't that hard to give a senior developer access to other
user accounts without giving them a DBA id. You the privileges 'create any
table, create public synonym' etc... instead of the DBA role and then they
do not have unneeded authority like adding files.
Andrew Protasov <protasov_at_percombank.kiev.ua> wrote in article >>
> Hi Mike,
>
> Our senior developers have access to DBA accounts in order to have
> simultaneous access to more than one developer's schema.
> This is necessary for example to synchronize schemas. It is
> quite hard to do this job without DBA account.
>
> Andrew Protasov
>
> Mike Oswald wrote in message <3574B0EB.706D8E1E_at_mitec.net>...
> >Okay... so we are going around and around... I came from the
> >Applications world and still do some development to support the DBA's
> >using Oracle*Forms. But recently the Apps Director insisted that his
> >Developers play/be the DBA's in an Oracle instance that we have setup
> >for them (for testing).
> >
> >They seem to think it is okay to have the SYSTEM/SYS account password(s)
> >and that they should be adding datafiles!
> >
> >-Mike
Received on Wed Jun 03 1998 - 08:59:59 CDT