oracle数据库如何创建用户并授予角色

目标：1.  创建角色test1_role,  授予 CREATE PROCEDURE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW 权限

        2. 创建用户test1_user,  授予 test1_role 角色

     

create role test1_role;
grant CREATE PROCEDURE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW to test1_role;
create  user test1_user identified by <password> ;
grant test1_role to test1_user;

 

转载于:https://www.cnblogs.com/liuxiya/p/6142052.html