cannot change password on accounts if user changing password does not have sysdba in logical
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