sql建用户建表语句

sql建用户语句

CREATE USER “DYKJ_AUTH” PROFILE “DEFAULT” IDENTIFIED BY “password”
DEFAULT TABLESPACE “ORCL” TEMPORARY TABLESPACE “TEMP” QUOTA UNLIMITED ON “ORCL” ACCOUNT UNLOCK ;
GRANT COMMENT ANY TABLE TO “DYKJ_AUTH” ;
GRANT CREATE ANY INDEX TO “DYKJ_AUTH” ;
GRANT CREATE ANY PROCEDURE TO “DYKJ_AUTH” ;
GRANT CREATE ANY SEQUENCE TO “DYKJ_AUTH” ;
GRANT CREATE ANY TABLE TO “DYKJ_AUTH” ;
GRANT CREATE ANY TRIGGER TO “DYKJ_AUTH” ;
GRANT CREATE ANY VIEW TO “DYKJ_AUTH” ;
GRANT CREATE DATABASE LINK TO “DYKJ_AUTH” ;
GRANT CREATE PUBLIC DATABASE LINK TO “DYKJ_AUTH” ;
GRANT DELETE ANY TABLE TO “DYKJ_AUTH” ;
GRANT INSERT ANY TABLE TO “DYKJ_AUTH” ;
GRANT SELECT ANY SEQUENCE TO “DYKJ_AUTH” ;
GRANT SELECT ANY TABLE TO “DYKJ_AUTH” ;
GRANT UPDATE ANY TABLE TO “DYKJ_AUTH” ;
GRANT “CONNECT” TO “DYKJ_AUTH” ;
GRANT “DBA” TO “DYKJ_AUTH” ;
REVOKE UNLIMITED TABLESPACE FROM “DYKJ_