Oracle创建用户和授权

在OracleXE中创建scott用户

1、打开SQL*Plus，以 sys用户登录数据库

connect / as sysdba

2、依次执行下面命令

--DROP USER scott CASCADE;

CREATE USER scott IDENTIFIED BY tiger;

GRANT connect,resource TO scott;

GRANT CREATE DATABASE LINK, CREATE MATERIALIZED VIEW TO scott;

GRANT CREATE PROCEDURE, CREATE PUBLIC SYNONYM TO scott;

GRANT CREATE ROLE, CREATE SEQUENCE TO scott;

GRANT CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER TO scott;

GRANT CREATE TYPE, CREATE VIEW TO scott;