
如果没设置,就是默认的用户名和密码,如下:
sys/change_on_install
system/manager
在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 用户名'
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)