{"id":2350,"date":"2018-01-26T16:01:27","date_gmt":"2018-01-26T07:01:27","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2350"},"modified":"2018-01-26T16:03:02","modified_gmt":"2018-01-26T07:03:02","slug":"oracle-12c-multitenant-%ec%bb%a8%ed%85%8c%ec%9d%b4%eb%84%88-pluggable-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ea%b4%80%eb%a6%ac","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=2350","title":{"rendered":"[Oracle 12c] Multitenant \ucee8\ud14c\uc774\ub108 \/ Pluggable \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac"},"content":{"rendered":"

<\/a>Multitenant <\/span>\ucee8\ud14c\uc774\ub108\/Pluggable \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac<\/span><\/h4>\n

Multitenant \ucee8\ud14c\uc774\ub108\/Pluggable \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. Multitenant \uc544\ud0a4\ud14d\uccd0\ub77c\uace0 \ud558\ub354\ub77c\ub3c4 \uae30\uc874 \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0ac\uc6a9 \ubc29\ubc95\uc774 \ud06c\uac8c \ub2e4\ub974\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774\ubc88\uc5d0\ub294 Multitenant \uc544\ud0a4\ud14d\uccd0\uc5d0\uc11c \uae30\uc874 \uad00\ub9ac \ubc29\uc2dd\uacfc\ub294 \uc57d\uac04\uc758 \ucc28\uc774\uac00 \uc788\ub294 \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\ubbf8\ud130 \uad00\ub9ac, \uc720\uc800 \uad00\ub9ac, \uad8c\ud55c \uad00\ub9ac\ub97c \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

<\/a>\uc778\uc2a4\ud134\uc2a4 <\/span>\ud30c\ub77c\ubbf8\ud130 \uad00\ub9ac<\/span><\/h6>\n

Pluggable \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\ubbf8\ud130 \ubcc0\uacbd \uc601\ud5a5\uc744 \u201cOPTIMIZER_USE_SQL_PLAN_BASELINES\u201d\ub97c \uc2e4\uc2b5\uc73c\ub85c \uc54c\uc544 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

SYS \uc720\uc800\ub85c Root \ucee8\ud14c\uc774\ub108 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud558\uc5ec \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\ubbf8\ud130 \u201cOPTIMIZER_USE_SQL_PLAN_BASELINES\u201d\uc758 Pluggable \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\uc758 \ubcc0\uacbd \uac00\ub2a5 \uc5ec\ubd80\ub97c v$parameter \ubdf0\uc5d0\uc11c \ud655\uc778\ud569\ub2c8\ub2e4. \u201cis_pdb_modifiable\u201d \uce7c\ub7fc \uac12\uc744 \ud1b5\ud574 PDB \ub808\ubca8\uc5d0\uc11c\ub3c4 \ubcc0\uacbd \uac00\ub2a5\ud55c \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\ubbf8\ud130 \uc784\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
[oracle@New-Features-12c ~]$ sqlplus \/ as sysdba<\/span><\/p>\n

SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 25 00:45:45 2015<\/span><\/p>\n

Copyright (c) 1982, 2014, Oracle. All rights reserved.<\/span><\/p>\n

Connected to:<\/span><\/p>\n

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production<\/span><\/p>\n

With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics<\/span><\/p>\n

and Real Application Testing options<\/span><\/p>\n

SQL> show con_name<\/span><\/p>\n

CON_NAME<\/span><\/p>\n

——————————<\/span><\/p>\n

CDB$ROOT<\/span><\/p>\n

SQL> col name for a40<\/span><\/p>\n

SQL> col value for a10<\/span><\/p>\n

SQL> select name,value,ispdb_modifiable from v$parameter where name = ‘optimizer_use_sql_plan_baselines’;<\/span><\/p>\n

NAME VALUE ISPDB<\/span><\/p>\n

—————————————- ———- —–<\/span><\/p>\n

optimizer_use_sql_plan_baselines TRUE TRUE<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc774\ubc88\uc5d0\ub294 [CDB1] \ub0b4 [PDB2]\uc5d0 \uc811\uc18d\ud574\uc11c OPTIMIZER_USE_SQL_PLAN_BASELINES \uc18d\uc131\uc744 \ud655\uc778\ud569\ub2c8\ub2e4. Root \ucee8\ud14c\uc774\ub108\uc640 \ub3d9\uc77c\ud558\uac8c \uc124\uc815\ub418\uc5b4 \uc788\uc74c\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect sys\/oracle_4U@pdb2 as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> show con_name<\/span><\/p>\n

CON_NAME<\/span><\/p>\n

——————————<\/span><\/p>\n

PDB2<\/span><\/p>\n

SQL> show parameter optimizer_use_sql_plan_baselines<\/span><\/p>\n

NAME TYPE VALUE<\/span><\/p>\n

———————————— ———– ——————————<\/span><\/p>\n

optimizer_use_sql_plan_baselines boolean TRUE<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[PDB2]\uc5d0 \uc811\uc18d\ud55c \uc0c1\ud0dc\uc5d0\uc11c OPTIMIZER_USE_SQL_PLAN_BASELINES \ub97c FALSE\ub85c \ubcc0\uacbd\ud558\uace0 \uc774\ub97c \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> alter system set optimizer_use_sql_plan_baselines=false scope=both;<\/span><\/p>\n

System altered.<\/span><\/p>\n

SQL> show parameter optimizer_use_sql_plan_baselines<\/span><\/p>\n

NAME TYPE VALUE<\/span><\/p>\n

———————————— ———– ——————————<\/span><\/p>\n

optimizer_use_sql_plan_baselines boolean FALSE<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[CDB1] \ub0b4 \ub610 \ub2e4\ub978 PDB\uc778 [PDB3] \uc5d0\uc11c\ub294 [PDB2]\uc5d0\uc11c \ubcc0\uacbd\ud55c \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\ubbf8\ud130 OPTIMIZER_USE_SQL_PLAN_BASELINES \uc18d\uc131\uc774 \uc5b4\ub5bb\uac8c \uc801\uc6a9\ub418\uc5b4 \uc788\ub294 \uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4. PDB \ub808\ubca8\uc5d0\uc11c \ubcc0\uacbd \uac00\ub2a5\ud55c \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\ubbf8\ud130\uc758 \uacbd\uc6b0, CDB \ub0b4 PDB\ub4e4 \uac04\uc5d0 \uc11c\ub85c \ub2e4\ub978 \uac12\uc774 \uc124\uc815 \ub420 \uc218 \uc788\uc74c\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect sys\/oracle_4U@pdb3 as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> show con_name<\/span><\/p>\n

CON_NAME<\/span><\/p>\n

——————————<\/span><\/p>\n

PDB3<\/span><\/p>\n

SQL> show parameter optimizer_use_sql_plan_baselines<\/span><\/p>\n

NAME TYPE VALUE<\/span><\/p>\n

———————————— ———– ——————————<\/span><\/p>\n

optimizer_use_sql_plan_baselines boolean TRUE<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc774\ubc88\uc5d0\ub294 [CDB1]\ub97c \uc7ac\uae30\ub3d9\ud558\uc5ec OPTIMIZER_USE_SQL_PLAN_BASELINES \uc124\uc815 \uac12\uc744 \uc804\uccb4\uc801\uc73c\ub85c \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. [CDB1]\uc5d0 \uc811\uc18d\ud574\uc11c \ud655\uc778\ud569\ub2c8\ub2e4. CDB \ub808\ubca8\uc5d0\uc11c\ub294 TRUE, [PDB2]\uc5d0\uc11c\ub294 FALSE\ub85c \uc124\uc815\ub418\uc5b4 \uc788\uc74c\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect \/ as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> shutdown immediate;<\/span><\/p>\n

Database closed.<\/span><\/p>\n

Database dismounted.<\/span><\/p>\n

ORACLE instance shut down.<\/span><\/p>\n

SQL> startup<\/span><\/p>\n

ORACLE instance started.<\/span><\/p>\n

Total System Global Area 6325010432 bytes<\/span><\/p>\n

Fixed Size 2938448 bytes<\/span><\/p>\n

Variable Size 2919238064 bytes<\/span><\/p>\n

Database Buffers 2113929216 bytes<\/span><\/p>\n

Redo Buffers 13836288 bytes<\/span><\/p>\n

In-Memory Area 1275068416 bytes<\/span><\/p>\n

Database mounted.<\/span><\/p>\n

Database opened.<\/span><\/p>\n

SQL> col value for a20<\/span><\/p>\n

SQL> select con_id,value from v$system_parameter where name = ‘optimizer_use_sql_plan_baselines’;<\/span><\/p>\n

CON_ID VALUE<\/span><\/p>\n

———- ——————–<\/span><\/p>\n

0 TRUE<\/span><\/p>\n

4 FALSE<\/span><\/p>\n

SQL> exit<\/span><\/p>\n

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production<\/span><\/p>\n

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/a>Common\/Local <\/span>\uc720\uc800 \uad00\ub9ac<\/span><\/h6>\n

Multitenant \ud658\uacbd\uc5d0\uc11c \uc720\uc800 \uad00\ub9ac\ub97c \uc2e4\uc2b5\uc744 \ud1b5\ud574 \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc6b0\uc120 Root \ucee8\ud14c\uc774\ub108\uc5d0 \uc811\uc18d\ud558\uc5ec \ubaa8\ub4e0 Common, Local \uc720\uc800 \ud604\ud669\uc744 \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
[oracle@New-Features-12c ~]$ sqlplus \/ as sysdba<\/span><\/p>\n

SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 25 01:11:02 2015<\/span><\/p>\n

Copyright (c) 1982, 2014, Oracle. All rights reserved.<\/span><\/p>\n

Connected to:<\/span><\/p>\n

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production<\/span><\/p>\n

With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics<\/span><\/p>\n

and Real Application Testing options<\/span><\/p>\n

SQL> set lines 100<\/span><\/p>\n

SQL> set pages 300<\/span><\/p>\n

SQL> col username for a50<\/span><\/p>\n

SQL> select username,common,con_id from cdb_users;<\/span><\/p>\n

USERNAME COM CON_ID<\/span><\/p>\n

—————————————- — ———-<\/span><\/p>\n

APEX_LISTENER YES 1<\/span><\/p>\n

ORACLE_OCM YES 1<\/span><\/p>\n

OJVMSYS YES 1<\/span><\/p>\n

:<\/span><\/p>\n

:<\/span><\/p>\n

:<\/span><\/p>\n

FLOWS_FILES YES 7<\/span><\/p>\n

DVF YES 7<\/span><\/p>\n

MDSYS YES 7<\/span><\/p>\n

:<\/span><\/p>\n

:<\/span><\/p>\n

:<\/span><\/p>\n

C##DBAAS_MONITOR YES 5<\/span><\/p>\n

SYSTEM YES 5<\/span><\/p>\n

SYS YES 5<\/span><\/p>\n

251 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc774\ubc88\uc5d0\ub294 SYSTEM \uc720\uc800\ub97c \ub515\uc154\ub108\ub9ac \ubdf0\uc5d0\uc11c \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uac01 \ucee8\ud14c\uc774\ub108\ubcc4\ub85c SYSTEM \uc720\uc800\uac00 \uc788\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> select username,common,con_id from cdb_users where username=’SYSTEM’ order by 3;<\/span><\/p>\n

USERNAME COM CON_ID<\/span><\/p>\n

—————————————- — ———-<\/span><\/p>\n

SYSTEM YES 1<\/span><\/p>\n

SYSTEM YES 3<\/span><\/p>\n

SYSTEM YES 4<\/span><\/p>\n

SYSTEM YES 5<\/span><\/p>\n

SYSTEM YES 6<\/span><\/p>\n

SYSTEM YES 7<\/span><\/p>\n

6 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[CDB1]\uc5d0 \uc0dd\uc131\ub41c \ubaa8\ub4e0 Common \uc720\uc800\ub97c \ud655\uc778\ud574 \ubd05\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> select distinct username from cdb_users where common=’YES’;<\/span><\/p>\n

USERNAME<\/span><\/p>\n

—————————————-<\/span><\/p>\n

MDSYS<\/span><\/p>\n

SYSTEM<\/span><\/p>\n

SYS<\/span><\/p>\n

:<\/span><\/p>\n

:<\/span><\/p>\n

:<\/span><\/p>\n

SPATIAL_CSW_ADMIN_USR<\/span><\/p>\n

ORACLE_OCM<\/span><\/p>\n

ORDSYS<\/span><\/p>\n

XDB<\/span><\/p>\n

LBACSYS<\/span><\/p>\n

SI_INFORMTN_SCHEMA<\/span><\/p>\n

39 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[CDB1]\uc5d0 \uc0dd\uc131\ub41c \uc720\uc800 \uc911 Common \uc720\uc800\uac00 \uc544\ub2cc \uc720\uc800\ub97c \uc870\ud68c\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> select username,con_id from cdb_users where common=’NO’ order by 2;<\/span><\/p>\n

USERNAME CON_ID<\/span><\/p>\n

—————————————- ———-<\/span><\/p>\n

DBAAS_MONITOR 3<\/span><\/p>\n

PM 3<\/span><\/p>\n

HR 3<\/span><\/p>\n

SCOTT 3<\/span><\/p>\n

IX 3<\/span><\/p>\n

BI 3<\/span><\/p>\n

PDBADMIN 3<\/span><\/p>\n

SH 3<\/span><\/p>\n

OE 3<\/span><\/p>\n

PDB_ADMIN 4<\/span><\/p>\n

PDB2_ADMIN 4<\/span><\/p>\n

PDB_ADMIN 5<\/span><\/p>\n

PDB3_ADMIN 5<\/span><\/p>\n

PDB3_ADMIN 6<\/span><\/p>\n

PDB_ADMIN 6<\/span><\/p>\n

PDB2_ADMIN 7<\/span><\/p>\n

PDB_ADMIN 7<\/span><\/p>\n

17 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc774\ubc88\uc5d0\ub294 [CDB1]\uc5d0 Common \uc720\uc800\ub97c \uc0dd\uc131\ud558\uace0 \uc774\ub97c \ud655\uc778\ud574 \ubd05\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> create user c##u identified by x container=all;<\/span><\/p>\n

User created.<\/span><\/p>\n

SQL> select username,common,con_id from cdb_users where username=’C##U’ order by 3;<\/span><\/p>\n

USERNAME COM CON_ID<\/span><\/p>\n

——————– — ———-<\/span><\/p>\n

C##U YES 1<\/span><\/p>\n

C##U YES 3<\/span><\/p>\n

C##U YES 4<\/span><\/p>\n

C##U YES 5<\/span><\/p>\n

C##U YES 6<\/span><\/p>\n

C##U YES 7<\/span><\/p>\n

6 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Common \uc720\uc800 [C##U]\uc5d0 CREATE SESSION \uad8c\ud55c\uc744 \ubd80\uc5ec\ud55c \ub4a4, [CDB1]\uacfc [CDB1] \ub0b4 \uac01 PDB\uc5d0 \uc811\uc18d\ud574 \ubd05\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> grant create session to c##u container=all;<\/span><\/p>\n

Grant succeeded.<\/span><\/p>\n

SQL> connect c##u\/x@pdb2<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> connect c##u\/x@pdb3<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> connect c##u\/x@cdb1<\/span><\/p>\n

Connected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

CONTAINER = ALL \uc635\uc158\uc740 Root \ucee8\ud14c\uc774\ub108\uc5d0\uc11c\ub9cc, CONTAINER = CURRENT \uc635\uc158\uc740 PDB\ub808\ubca8\uc5d0\uc11c\ub9cc \uc124\uc815 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/span><\/p>\n

\uc774\ub97c \ud655\uc778\ud558\uae30 \uc704\ud574 Root \ucee8\ud14c\uc774\ub108\uc5d0\uc11c Local \uc720\uc800\ub97c \ub9cc\ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 ORA-65049 \uc5d0\ub7ec\ub97c \ub9ac\ud134\ud558\uac8c \ub429\ub2c8\ub2e4. Root \ucee8\ud14c\uc774\ub108\uc5d0\uc11c\ub294 Local \uc720\uc800\uac00 \uc0dd\uc131\uc774 \ub418\uc9c0 \uc54a\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect \/ as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> show con_name<\/span><\/p>\n

CON_NAME<\/span><\/p>\n

——————————<\/span><\/p>\n

CDB$ROOT<\/span><\/p>\n

SQL> create user lu identified by x container=current;<\/span><\/p>\n

create user lu identified by x container=current<\/span><\/p>\n

*<\/span><\/p>\n

ERROR at line 1:<\/span><\/p>\n

ORA-65049: creation of local user or role is not allowed in CDB$ROOT<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[PDB2]\uc5d0 \uc811\uc18d\ud574\uc11c Common \uc720\uc800\ub97c \ub9cc\ub4e4\uc5b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc774\ubc88\uc5d0\ub294 ORA-65050 \uc5d0\ub7ec\ub97c \ub9ac\ud134\ud569\ub2c8\ub2e4. PDB \ub808\ubca8\uc5d0\uc11c\ub294 Common \uc720\uc800\ub97c \uc0dd\uc131\ud560 \uc218 \uc5c6\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect sys\/oracle_4U@pdb2 as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> create user c##u_pdb2 identified by x container=all;<\/span><\/p>\n

create user c##u_pdb2 identified by x container=all<\/span><\/p>\n

*<\/span><\/p>\n

ERROR at line 1:<\/span><\/p>\n

ORA-65050: Common DDLs only allowed in CDB$ROOT<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uadf8\ub807\ub2e4\uba74 \uc774\ubc88\uc5d0\ub294 [PDB2]\uc5d0 \uc811\uc18d\ud55c \uc0c1\ud0dc\uc5d0\uc11c Local \uc720\uc800\ub97c \ub9cc\ub4e4\uace0, \ub515\uc154\ub108\ub9ac \ubdf0\uc5d0\uc11c \uc774\ub97c \ud655\uc778\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. CREATE SESSION \uad8c\ud55c\ub3c4 \ubd80\uc5ec\ud569\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> show con_name<\/span><\/p>\n

CON_NAME<\/span><\/p>\n

——————————<\/span><\/p>\n

PDB2<\/span><\/p>\n

SQL> create user lu identified by x container=current;<\/span><\/p>\n

User created.<\/span><\/p>\n

SQL> select username,common,con_id from cdb_users where username=’LU’;<\/span><\/p>\n

USERNAME COM CON_ID<\/span><\/p>\n

——————– — ———-<\/span><\/p>\n

LU NO 4<\/span><\/p>\n

SQL> grant create session to lu;<\/span><\/p>\n

Grant succeeded.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc0dd\uc131\ud55c Local \uc720\uc800 [LU]\uc758 \uc811\uc18d \ud14c\uc2a4\ud2b8\ub97c \ud574 \ubd05\ub2c8\ub2e4. [PDB2]\uc5d0\uc11c \uc0dd\uc131\ud55c Local \uc720\uc800\ub294 \ub2e4\ub978 PDB\ub098 Root \ucee8\ud14c\uc774\ub108\uc5d0\uc11c\ub294 \uc811\uc18d\ud560 \uc218 \uc5c6\uc74c\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect lu\/x@pdb2<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> connect lu\/x@pdb3<\/span><\/p>\n

ERROR:<\/span><\/p>\n

ORA-01017: invalid username\/password; logon denied<\/span><\/p>\n

Warning: You are no longer connected to ORACLE.<\/span><\/p>\n

SQL> connect lu\/x@cdb1<\/span><\/p>\n

ERROR:<\/span><\/p>\n

ORA-01017: invalid username\/password; logon denied<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\ub2e4\uc2dc [PDB2]\uc5d0 \uc811\uc18d\ud55c \uc0c1\ud0dc\uc5d0\uc11c \ubaa8\ub4e0 \uc720\uc800 \ud604\ud669\ub97c \ud655\uc778\ud574 \ubd05\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 cdb_user\uc640 dba_users\uc5d0\uc11c \ubcf4\uc5ec \uc8fc\ub294 \uc720\uc800 \ubaa9\ub85d\uc740 \ub3d9\uc77c\ud55c \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect sys\/oracle_4U@pdb2 as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> show con_name<\/span><\/p>\n

CON_NAME<\/span><\/p>\n

——————————<\/span><\/p>\n

PDB2<\/span><\/p>\n

SQL> select username,common,con_id from cdb_users order by 1;<\/span><\/p>\n

USERNAME COM CON_ID<\/span><\/p>\n

——————– — ———-<\/span><\/p>\n

ANONYMOUS YES 4<\/span><\/p>\n

APEX_040200 YES 4<\/span><\/p>\n

APEX_LISTENER YES 4<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n
:<\/span><\/p>\n

:<\/span><\/p>\n

:<\/span><\/p>\n

SYSKM YES 4<\/span><\/p>\n

SYSTEM YES 4<\/span><\/p>\n

WMSYS YES 4<\/span><\/p>\n

XDB YES 4<\/span><\/p>\n

XS$NULL YES 4<\/span><\/p>\n

43 rows selected.<\/span><\/p>\n

SQL> select username,common from cdb_users minus select username,common from dba_users;<\/span><\/p>\n

no rows selected<\/span><\/p>\n

SQL> select username,common from dba_users minus select username,common from cdb_users;<\/span><\/p>\n

no rows selected<\/span><\/p>\n

SQL> select count(*) from cdb_users;<\/span><\/p>\n

COUNT(*)<\/span><\/p>\n

———-<\/span><\/p>\n

43<\/span><\/p>\n

SQL> select count(*) from dba_users;<\/span><\/p>\n

COUNT(*)<\/span><\/p>\n

———-<\/span><\/p>\n

43<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/a>Common\/Local <\/span>\uad8c\ud55c \uad00\ub9ac<\/span><\/h6>\n

Privilege \uc790\uccb4\ub294 Common\/Local \uad6c\ubd84\uc774 \uc5c6\uc2b5\ub2c8\ub2e4. \ub2e4\ub9cc Common \ub610\ub294 Local\ub85c \ubd80\uc5ec\ub420 \ubfd0\uc785\ub2c8\ub2e4. \uad00\ub828 \ub515\uc154\ub108\ub9ac \ubdf0\ub97c \uc870\ud68c\ud574 \ubcf4\uba74 COMMON \uce7c\ub7fc\uc774 \uc5c6\ub294 \uac83\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect \/ as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> show con_name<\/span><\/p>\n

CON_NAME<\/span><\/p>\n

——————————<\/span><\/p>\n

CDB$ROOT<\/span><\/p>\n

SQL> desc sys.system_privilege_map<\/span><\/p>\n

Name Null? Type<\/span><\/p>\n

—————————————————– ——– —————————-<\/span><\/p>\n

PRIVILEGE NOT NULL NUMBER<\/span><\/p>\n

NAME NOT NULL VARCHAR2(40)<\/span><\/p>\n

PROPERTY NOT NULL NUMBER<\/span><\/p>\n

SQL> desc sys.table_privilege_map<\/span><\/p>\n

Name Null? Type<\/span><\/p>\n

—————————————————– ——– —————————-<\/span><\/p>\n

PRIVILEGE NOT NULL NUMBER<\/span><\/p>\n

NAME NOT NULL VARCHAR2(40)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc55e\uc120 \uc2e4\uc2b5\uc5d0\uc11c \uc0dd\uc131\ud55c \uc720\uc800 [C##U]\uc640 [LU]\uc5d0 CREATE SESSION \uad8c\ud55c\uc774 \uc5b4\ub5bb\uac8c \ubd80\uc5ec\ub418\uc5b4 \uc788\ub294 \uc9c0 \ud655\uc778\ud574 \ubd05\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> col grantee for a20<\/span><\/p>\n

SQL> col privilege for a20<\/span><\/p>\n

SQL> select grantee,privilege,common,con_id from cdb_sys_privs where grantee in (‘C##U’,’LU’) order by 4;<\/span><\/p>\n

GRANTEE PRIVILEGE COM CON_ID<\/span><\/p>\n

——————– ——————– — ———-<\/span><\/p>\n

C##U CREATE SESSION YES 1<\/span><\/p>\n

C##U CREATE SESSION YES 3<\/span><\/p>\n

C##U CREATE SESSION YES 4<\/span><\/p>\n

LU CREATE SESSION NO 4<\/span><\/p>\n

C##U CREATE SESSION YES 5<\/span><\/p>\n

C##U CREATE SESSION YES 6<\/span><\/p>\n

C##U CREATE SESSION YES 7<\/span><\/p>\n

7 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[PDB2]\uc5d0 \uc811\uc18d\ud588\uc744 \ub54c, PDB \ub808\ubca8\uc5d0\uc11c\ub294 \ubd80\uc5ec\ub41c \uad8c\ud55c \uc815\ubcf4\uac00 \uc5b4\ub5bb\uac8c \ubcf4\uc774\ub294 \uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect sys\/oracle_4U@pdb2 as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> select grantee,privilege,common from dba_sys_privs where grantee in (‘C##U’,’LU’);<\/span><\/p>\n

GRANTEE PRIVILEGE COM<\/span><\/p>\n

——————– ——————– —<\/span><\/p>\n

LU CREATE SESSION NO<\/span><\/p>\n

C##U CREATE SESSION YES<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Root \ucee8\ud14c\uc774\ub108\uc5d0\uc11c Common \uc720\uc800 [C##U] \uc5d0 CREATE TABLE, UNLIMITED TABLESPACE \uad8c\ud55c\uc744 \ubd80\uc5ec\ud558\uace0, \ubaa8\ub4e0 PDB\uc5d0 \ubc18\uc601\ub418\ub294 \uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect sys\/oracle_4U@cdb1 as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> grant create table, unlimited tablespace to c##u container=all;<\/span><\/p>\n

Grant succeeded.<\/span><\/p>\n

SQL> set pages 100<\/span><\/p>\n

SQL> col grantee for a15<\/span><\/p>\n

SQL> col privilege for a30<\/span><\/p>\n

SQL> select grantee,privilege,common,con_id from cdb_sys_privs where grantee=’C##U’ order by 2,4;<\/span><\/p>\n

GRANTEE PRIVILEGE COM CON_ID<\/span><\/p>\n

————— —————————— — ———-<\/span><\/p>\n

C##U CREATE SESSION YES 1<\/span><\/p>\n

C##U CREATE SESSION YES 3<\/span><\/p>\n

C##U CREATE SESSION YES 4<\/span><\/p>\n

C##U CREATE SESSION YES 5<\/span><\/p>\n

C##U CREATE SESSION YES 6<\/span><\/p>\n

C##U CREATE SESSION YES 7<\/span><\/p>\n

C##U CREATE TABLE YES 1<\/span><\/p>\n

C##U CREATE TABLE YES 3<\/span><\/p>\n

C##U CREATE TABLE YES 4<\/span><\/p>\n

C##U CREATE TABLE YES 5<\/span><\/p>\n

C##U CREATE TABLE YES 6<\/span><\/p>\n

C##U CREATE TABLE YES 7<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 1<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 3<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 4<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 5<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 6<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 7<\/span><\/p>\n

18 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

CREATE SEQUENCE \uad8c\ud55c\uc744 Common \uc720\uc800 [C##U]\uc5d0 \ubd80\uc5ec\ud558\ub418 Root \ucee8\ud14c\uc774\ub108\uc5d0\ub9cc \uc801\uc6a9\ub418\ub3c4\ub85d \ubd80\uc5ec\ud569\ub2c8\ub2e4. \uc774\ub294 Local \uad8c\ud55c\uc774 \ub429\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> show con_name<\/span><\/p>\n

CON_NAME<\/span><\/p>\n

——————————<\/span><\/p>\n

CDB$ROOT<\/span><\/p>\n

SQL> grant create sequence to c##u container=current;<\/span><\/p>\n

Grant succeeded.<\/span><\/p>\n

SQL> select grantee,privilege,common,con_id from cdb_sys_privs where grantee=’C##U’ order by 2,4;<\/span><\/p>\n

GRANTEE PRIVILEGE COM CON_ID<\/span><\/p>\n

————— —————————— — ———-<\/span><\/p>\n

C##U CREATE SEQUENCE NO 1<\/span><\/p>\n

C##U CREATE SESSION YES 1<\/span><\/p>\n

C##U CREATE SESSION YES 3<\/span><\/p>\n

C##U CREATE SESSION YES 4<\/span><\/p>\n

C##U CREATE SESSION YES 5<\/span><\/p>\n

C##U CREATE SESSION YES 6<\/span><\/p>\n

C##U CREATE SESSION YES 7<\/span><\/p>\n

C##U CREATE TABLE YES 1<\/span><\/p>\n

C##U CREATE TABLE YES 3<\/span><\/p>\n

C##U CREATE TABLE YES 4<\/span><\/p>\n

C##U CREATE TABLE YES 5<\/span><\/p>\n

C##U CREATE TABLE YES 6<\/span><\/p>\n

C##U CREATE TABLE YES 7<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 1<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 3<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 4<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 5<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 6<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 7<\/span><\/p>\n

19 rows selected.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\uc774\ubc88\uc5d0\ub294 CREATE SYNONYM \uad8c\ud55c\uc744 Common \uc720\uc800 [C##U]\uc5d0 \ubd80\uc5ec\ud558\ub418 [PDB2]\uc5d0\uc11c\ub9cc \uc801\uc6a9\ub418\ub3c4\ub85d \ubd80\uc5ec\ud569\ub2c8\ub2e4. (Local \uad8c\ud55c)<\/span><\/p>\n\n\n\n
SQL> connect sys\/oracle_4U@pdb2 as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> grant create synonym to c##u container=current;<\/span><\/p>\n

Grant succeeded.<\/span><\/p>\n

SQL> select grantee,privilege,common,con_id from cdb_sys_privs where grantee=’C##U’ order by 2,4;<\/span><\/p>\n

GRAN PRIVILEGE COM CON_ID<\/span><\/p>\n

—- —————————————- — ———-<\/span><\/p>\n

C##U CREATE SESSION YES 4<\/span><\/p>\n

C##U CREATE SYNONYM NO 4<\/span><\/p>\n

C##U CREATE TABLE YES 4<\/span><\/p>\n

C##U UNLIMITED TABLESPACE YES 4<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

CREAE VIEW \uad8c\ud55c\uc744 [PDB2]\uc5d0 \uc811\uc18d\ud55c \ucc44 Common \uc720\uc800 [C##U]\uc5d0 \ubd80\uc5ec\ud558\ub418 \uc774\ubc88\uc5d0\ub294 Root \ucee8\ud14c\uc774\ub108\ub97c \ud3ec\ud568\ud55c \ubaa8\ub4e0 \ucee8\ud14c\uc774\ub108\uc5d0 \uc801\uc6a9\ub418\ub3c4\ub85d \ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc989 [PDB2]\uc5d0\uc11c Common \uad8c\ud55c\uc744 \ubd80\uc5ec\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0, ORA-65050 \uc5d0\ub7ec\ub97c \ub9ac\ud134\ud558\uac8c \ub418\ub294\ub370 PDB\ub808\ubca8\uc5d0\uc11c\ub294 Common \uad88\ud55c\uc744 \ubd80\uc5ec\ud560 \uc218 \uc5c6\uc74c\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> show con_name<\/span><\/p>\n

CON_NAME<\/span><\/p>\n

——————————<\/span><\/p>\n

PDB2<\/span><\/p>\n

SQL> grant create view to c##u container=all;<\/span><\/p>\n

grant create view to c##u container=all<\/span><\/p>\n

*<\/span><\/p>\n

ERROR at line 1:<\/span><\/p>\n

ORA-65050: Common DDLs only allowed in CDB$ROOT<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\ud2b9\uc815 PDB\uc758 Local \uc720\uc800\uc5d0\uac8c \ubd80\uc5ec\ud558\ub294 \uad8c\ud55c\uc774 \ubaa8\ub4e0 \ucee8\ud14c\uc774\ub108\uc5d0 \uc801\uc6a9\ub418\ub3c4\ub85d \ud558\ub294 \uac83 \uc5ed\uc2dc \ubd88\uac00\ud569\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect sys\/oracle_4U as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> show con_name<\/span><\/p>\n

CON_NAME<\/span><\/p>\n

——————————<\/span><\/p>\n

CDB$ROOT<\/span><\/p>\n

SQL> grant create any table to lu container=all;<\/span><\/p>\n

grant create any table to lu container=all<\/span><\/p>\n

*<\/span><\/p>\n

ERROR at line 1:<\/span><\/p>\n

ORA-01917: user or role ‘LU’ does not exist<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\ud2b9\uc815 PDB\uc758 Local \uc720\uc800\uc5d0\uac8c \ubd80\uc5ec\ud558\ub294 \uad8c\ud55c\uc774 Root \ucee8\ud14c\uc774\ub108\uc5d0\uc11c \uc801\uc6a9\ub418\ub3c4\ub85d \ud558\ub294 \uac83\ub3c4 \ubd88\uac00\ud569\ub2c8\ub2e4. \ud574\ub2f9 \uc720\uc800\uac00 Root \ucee8\ud14c\uc774\ub108\uc5d0\ub294 \uc5c6\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> grant create any sequence to lu container=current;<\/span><\/p>\n

grant create any sequence to lu container=current<\/span><\/p>\n

*<\/span><\/p>\n

ERROR at line 1:<\/span><\/p>\n

ORA-01917: user or role ‘LU’ does not exist<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\ud2b9\uc815 PDB\uc758 Local \uc720\uc800\uc5d0\uac8c \ubd80\uc5ec\ud558\ub294 \uad8c\ud55c\uc774 \ud574\ub2f9 PDB\uc5d0\uc11c\ub9cc \uc801\uc6a9\ub418\ub3c4\ub85d \ud558\ub294 \uac83\uc740 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> connect sys\/oracle_4U@pdb2 as sysdba<\/span><\/p>\n

Connected.<\/span><\/p>\n

SQL> grant unlimited tablespace to lu container=current;<\/span><\/p>\n

Grant succeeded.<\/span><\/p>\n

SQL> select grantee,privilege,common,con_id from cdb_sys_privs where grantee=’LU’;<\/span><\/p>\n

GRANTEE PRIVILEGE COM CON_ID<\/span><\/p>\n

———- —————————————- — ———-<\/span><\/p>\n

LU UNLIMITED TABLESPACE NO 4<\/span><\/p>\n

LU CREATE SESSION NO 4<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\ud558\uc9c0\ub9cc Local \uc720\uc800\uc5d0\uac8c \ubd80\uc5ec\ud558\ub294 Local \uad8c\ud55c\uc774 \ub2e4\ub978 \ucee8\ud14c\uc774\ub108\uc5d0\ub3c4 \uc801\uc6a9\ub418\ub3c4\ub85d \ud558\ub294 \uac83\uc740 \ubd88\uac00\ud569\ub2c8\ub2e4.<\/span><\/p>\n\n\n\n
SQL> grant drop any view to lu container=all;<\/span><\/p>\n

grant drop any view to lu container=all<\/span><\/p>\n

*<\/span><\/p>\n

ERROR at line 1:<\/span><\/p>\n

ORA-65030: one may not grant a Common Privilege to a Local User or Role<\/span><\/p>\n

SQL> exit<\/span><\/p>\n

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production<\/span><\/p>\n

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Multitenant \ucee8\ud14c\uc774\ub108\/Pluggable \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac Multitenant \ucee8\ud14c\uc774\ub108\/Pluggable \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. Multitenant \uc544\ud0a4\ud14d\uccd0\ub77c\uace0 \ud558\ub354\ub77c\ub3c4 \uae30\uc874 \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0ac\uc6a9 \ubc29\ubc95\uc774 \ud06c\uac8c \ub2e4\ub974\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uc774\ubc88\uc5d0\ub294 Multitenant \uc544\ud0a4\ud14d\uccd0\uc5d0\uc11c \uae30\uc874 \uad00\ub9ac \ubc29\uc2dd\uacfc\ub294 \uc57d\uac04\uc758 \ucc28\uc774\uac00 \uc788\ub294 \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\ubbf8\ud130 \uad00\ub9ac, \uc720\uc800 \uad00\ub9ac, \uad8c\ud55c \uad00\ub9ac\ub97c \uc0b4\ud3b4 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\ubbf8\ud130 \uad00\ub9ac Pluggable \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc778\uc2a4\ud134\uc2a4 \ud30c\ub77c\ubbf8\ud130 \ubcc0\uacbd \uc601\ud5a5\uc744 \u201cOPTIMIZER_USE_SQL_PLAN_BASELINES\u201d\ub97c \uc2e4\uc2b5\uc73c\ub85c \uc54c\uc544 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. SYS \uc720\uc800\ub85c […]<\/p>\n","protected":false},"author":1,"featured_media":2333,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[20],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/logo-oracle12.png?fit=720%2C166&ssl=1","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2350"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2350"}],"version-history":[{"count":2,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2350\/revisions"}],"predecessor-version":[{"id":2352,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2350\/revisions\/2352"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2333"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}