oracle数据库创建用户、 创建角色和权限管理代码示例

1)       创建用户USR_124451
CREATE USER USR_124451

IDENTIFIED BY "ad3lmasdfdfc23,bt"

DEFAULT TABLESPACE T4_GAE

TEMPORARY TABLESPACE TBST_BBD

QUOTA 9M on T4_GAE

PROFILE PRO_271;

2)       给用户USR_124451赋创建序列的权限
GRANT Create sequence

to USR_124451

WITH ADMIN OPTION;

3)       给用户USR_124451赋分区表RJCCOU_DBG2上删除记录的权限
GRANT delete

on system.RJCCOU_DBG2

to USR_124451

WITH GRANT OPTION;

4)       创建角色ROL_080
CREATE ROLE ROL_080

IDENTIFIED BYscxsygl;

5)       赋修改表空间的权限给角色ROL_080
GRANT ALTER TABLESPACE

to ROL_080

WITH ADMIN OPTION;

6)       赋表RJCPAR_FBB4上查询记录的权限给角色ROL_080
GRANT select

ON system.RJCPAR_FBB4

to ROL_080;

7)       把角色ROL_080赋给用户USR_124451
GRANT ROL_080
to USR_124451;

8)       修改用户USR_124451的缺省角色
ALTER USER USR_124451 DEFAULT ROLE ALL EXCEPT ROL_080;