crt中 新建的连接存储在哪,电脑创建新用户后新用户的数据保存在哪里?

在CRT中进入oracle --连接sqlplus

按照下面写完代码直接复制进去回车就行了

---建立用户代码为：CREATE USER "用户名字" PROFILE "DEFAULT" IDENTIFIED BY "密码" DEFAULT TABLESPACE "指定表空间名字" TEMPORARY TABLESPACE "临时表空间" ACCOUNT UNLOCK;

---赋权

begin

EXECUTE IMMEDIATE 'GRANT SELECT ANY DICTIONARY TO 用户名';

EXECUTE IMMEDIATE 'GRANT ALTER ANY TABLE TO 用户名';

EXECUTE IMMEDIATE 'GRANT ALTER SYSTEM TO 用户名';

EXECUTE IMMEDIATE 'GRANT ALTER ANY PROCEDURE TO 用户名';

EXECUTE IMMEDIATE 'GRANT CONNECT TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE ANY PROCEDURE TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE ANY TABLE TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE ANY INDEX TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE DATABASE LINK TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE PUBLIC DATABASE LINK TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE ANY VIEW TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE PUBLIC SYNONYM TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE TABLE TO 用户名';

EXECUTE IMMEDIATE 'GRANT DELETE ANY TABLE TO 用户名';

EXECUTE IMMEDIATE 'GRANT DROP PUBLIC DATABASE LINK TO 用户名';

EXECUTE IMMEDIATE 'GRANT DROP ANY TRIGGER TO 用户名';

EXECUTE IMMEDIATE 'GRANT DROP ANY INDEX TO 用户名';

EXECUTE IMMEDIATE 'GRANT DROP ANY PROCEDURE TO 用户名';

EXECUTE IMMEDIATE 'GRANT DROP ANY TABLE TO 用户名';

EXECUTE IMMEDIATE 'GRANT DROP ANY VIEW TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE PUBLIC SYNONYM TO 用户名';

EXECUTE IMMEDIATE 'GRANT DROP PUBLIC SYNONYM TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE ANY SEQUENCE TO 用户名';

EXECUTE IMMEDIATE 'GRANT EXECUTE ANY PROCEDURE TO 用户名';

EXECUTE IMMEDIATE 'GRANT GRANT ANY PRIVILEGE TO 用户名';

EXECUTE IMMEDIATE 'GRANT GRANT ANY ROLE TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE ANY TRIGGER TO 用户名';

EXECUTE IMMEDIATE 'GRANT INSERT ANY TABLE TO 用户名';

EXECUTE IMMEDIATE 'GRANT SELECT ANY DICTIONARY TO 用户名';

EXECUTE IMMEDIATE 'GRANT SELECT ANY SEQUENCE TO 用户名';

EXECUTE IMMEDIATE 'GRANT DROP ANY SEQUENCE TO 用户名';

EXECUTE IMMEDIATE 'GRANT SELECT ANY TABLE TO 用户名';

EXECUTE IMMEDIATE 'GRANT UNLIMITED TABLESPACE TO 用户名';

EXECUTE IMMEDIATE 'GRANT UPDATE ANY TABLE TO 用户名';

EXECUTE IMMEDIATE 'GRANT COMMENT ANY TABLE TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE ANY TYPE TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE TABLESPACE TO 用户名';

EXECUTE IMMEDIATE 'GRANT CREATE USER TO 用户名';

EXECUTE IMMEDIATE 'GRANT EXP_FULL_DATABASE TO 用户名';

EXECUTE IMMEDIATE 'GRANT IMP_FULL_DATABASE TO 用户名';

End;

---或者直接给DBA权限希望有所提示，有空到CSDN,IT实验室,365testing进一步交流!

取消

评论