Getting feet wet with users in Multi-Tenant Users and 12c
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 22 Mar 2016 09:25:12 -0500
Message-ID: <CAP79kiSH8+PjnQuTaeRpG2Az1KcJtP5gBvbWGQxASjCdkUSAHg_at_mail.gmail.com>
Ok, we have a POC 12c environment and I'm just getting started so I had a couple of questions regarding USERS.
Date: Tue, 22 Mar 2016 09:25:12 -0500
Message-ID: <CAP79kiSH8+PjnQuTaeRpG2Az1KcJtP5gBvbWGQxASjCdkUSAHg_at_mail.gmail.com>
Ok, we have a POC 12c environment and I'm just getting started so I had a couple of questions regarding USERS.
1.) The SYS password for the CDB is not the same as the PDB - does SYS exist in the PDB? I can connect fine to the CDB " connect sys as sysdba", but the inside the PDB (using tnsnames alias), it gives me invalid username/password.
2.) When creating users inside the PDB, do I have to do it while connected to the CDB and do an "alter session set container = xxxxxx;" then create the user? Or can I login directly to the PDB service and create the user? I'm hoping I can login directly to the PDB and create the user, but then I'm curious why my SYS password doesn't work going to the PDB.
Tips/Suggestions?
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 22 2016 - 15:25:12 CET