drop user SH cascade;
/* 创建AMSDBO 用户 */
CREATE USER "SH" PROFILE "DEFAULT"
IDENTIFIED BY "181818" DEFAULT TABLESPACE "USERS"
ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "SH" WITH ADMIN OPTION;
GRANT "CONNECT" TO "SH" WITH ADMIN OPTION;
GRANT "DBA" TO "SH" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "SH" WITH ADMIN OPTION;
GRANT CREATE ANY SEQUENCE TO "SH";
commit;
--update users set vc_user_password = 't{4bs1^5'
/* 创建AMSDBO 用户 */
CREATE USER "SH" PROFILE "DEFAULT"
IDENTIFIED BY "181818" DEFAULT TABLESPACE "USERS"
ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "SH" WITH ADMIN OPTION;
GRANT "CONNECT" TO "SH" WITH ADMIN OPTION;
GRANT "DBA" TO "SH" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "SH" WITH ADMIN OPTION;
GRANT CREATE ANY SEQUENCE TO "SH";
commit;
--update users set vc_user_password = 't{4bs1^5'