怎样在linux中的oracle创建用户名和密码

2025-02-25 17:29:16
推荐回答(2个)
回答1:

在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 用户名';

回答2:

Oracle在安装时会要求你输入SYS和SYSTEM账户的密码。你可以先用SYS账户登录,然后建立你的用户。