Oracle 创建用户CREATE USER "LNCKQ" PROFILE "DEFAULT" IDENTIFIED BY "LNCKQ" DEFAULT TABLESPACE "GTOA" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;GRANT"CONNECT" TO "LNCKQ" WITH ADMIN OPTION;GRANT"DBA" TO "LNCKQ" WITH ADMIN OPTION;这段是啥意思

Oracle 创建用户CREATE USER "LNCKQ" PROFILE "DEFAULT" IDENTIFIED BY "LNCKQ" DEFAULT TABLESPACE "GTOA" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;GRANT"CONNECT" TO "LNCKQ" WITH ADMIN OPTION;GRANT"DBA" TO "LNCKQ" WITH ADMIN OPTION;这段是啥意思
Oracle 创建用户
CREATE USER "LNCKQ" PROFILE "DEFAULT"
IDENTIFIED
BY "LNCKQ" DEFAULT TABLESPACE "GTOA"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;
GRANT"CONNECT" TO "LNCKQ" WITH ADMIN OPTION;
GRANT"DBA" TO "LNCKQ" WITH ADMIN OPTION;
这段是啥意思 刚学ORACLE,以前学SQL的.

Oracle 创建用户CREATE USER "LNCKQ" PROFILE "DEFAULT" IDENTIFIED BY "LNCKQ" DEFAULT TABLESPACE "GTOA" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;GRANT"CONNECT" TO "LNCKQ" WITH ADMIN OPTION;GRANT"DBA" TO "LNCKQ" WITH ADMIN OPTION;这段是啥意思
CREATE USER "LNCKQ" 创建一个用户,名称为 LNCKQ
IDENTIFIED BY "LNCKQ" 密码为LNCKQ
DEFAULT TABLESPACE "GTOA" 默认表空间是 GTOA
TEMPORARY TABLESPACE "TEMP" 临时表空间是 TEMP
ACCOUNT UNLOCK; 帐号正常未锁定
GRANT"CONNECT" TO "LNCKQ" WITH ADMIN OPTION;
授予用户LNCKQ 创建连接的角色,并可再授权
GRANT"DBA" TO "LNCKQ" WITH ADMIN OPTION;
授予用户LNCKQ 数据库管理员的橘色,并可再授权