High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

cannot change password on accounts if user changing password does not have sysdba in logical

I may be missing something here, but I cannot find it.  I can create a user in the primary database and that user can change passwords.  If I create a new user in the logical standby, it cannot change passwords.  Here is the scenario:

 I created 2 accounts:

Primary database: gave the new user- alter user, create session, create table with quota.   

     this user can log into the primary database and change any password

Logical standby in READ-ONLY mode with a new default tablespace created in the logical standby:

   created another user with the same privileges, and get every time: ORA-01031: insufficient privileges

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center