创建用户并赋予权限

it2022-05-05  117

CREATE USER "XIR_MD_J"  PROFILE "DEFAULT"      IDENTIFIED BY "xpar" DEFAULT TABLESPACE "XIR_MD_DAT"      TEMPORARY TABLESPACE "TEMP"      ACCOUNT UNLOCK; GRANT UNLIMITED TABLESPACE TO "XIR_MD_J"; GRANT "CONNECT" TO "XIR_MD_J"; GRANT "RESOURCE" TO "XIR_MD_J"; GRANT DBA TO "XIR_MD_J";


最新回复(0)