how to create local user in Database 12c [message #601877] |
Tue, 26 November 2013 10:34 |
irsathahamed
Messages: 12 Registered: April 2008 Location: UAE
|
Junior Member |
|
|
Hello,
Can you please anyone guide me how to create local user in Oracle Database 12c.
I just installed fresh copy and I want to create. I have read about new concept in 12c regarding common user and local user but i dont understand how to create local user.
Kindly help me.
I am using Oracle 12c in Windows 8.1 pro 64bit operating system.
Thanks in advace.
|
|
|
|
Re: how to create local user in Database 12c [message #601889 is a reply to message #601877] |
Tue, 26 November 2013 12:42 |
Solomon Yakobson
Messages: 3273 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
Do you have multitenant environment? Common/local applies only if you do. Anyway, common is user created at root level with name starting with C##. You don't need, among other things, to create common user in every PDB - common user is known to any (event future) PDBs. Local user is user you create in a pluggable database and it can only connect to that PDB.
SY.
|
|
|