Re: RMAN: Duplication and SYSDBA

The SYSDBA privilege is special. Users that have it, are stored in the password file, not in the database. You must've recreated that file when you created a clone of the database.

After a duplicate you will have to re-grant the SYSDBA privilege to all the users that had it in the original, if you wish to keep it.

Stefan

On 12/5/06, John P Weatherman <jweatherman91_at_alumni.wfu.edu> wrote:
>
> All,
>
> After replicating to a development database with RMAN (duplicate target
> database to ...) we are noticing that an account (SYSTEM) is losing its
> SYSDBA grant. I haven't been able to find any documentation that this
> is or is not supposed to be happening. Does anyone have any
> experience/insight into what may be happening? Could I be missing a
> setting somewhere or is this just a "manually reissue to grant when
> adding the tempfile" type of thing?
>
> TIA,
>
> John
>
>
> ---
> John P Weatherman
> Oracle DBA
> Madison River Communications
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l