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;
上一篇:在外部怎么调用jquery插件里的function


下一篇:java itext 报错 com.itextpdf.text.DocumentException: Font 'STSong-Light' with 'UniGB-UCS2-H'