Re: RMAN: Duplication and SYSDBA
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: jweatherman91@xxxxxxxxxxxxxx
- Date: Tue, 5 Dec 2006 14:41:42 +0100
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@xxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
