oracle11g 添加用户,oracle11g 创建用户并授权

Oracle创建用户并给用户授权查询指定表或视图的权限

用sys账户登录数据库进行如下操作：

CREATE USER NORTHBOUND IDENTIFIED BY NORTHBOUND

DEFAULT TABLESPACE "TBS_DNINMSV31"

TEMPORARY TABLESPACE "TEMP2"

QUOTA UNLIMITED ON "TBS_DNINMSV31";

GRANT "CONNECT" TO NORTHBOUND;

ALTER USER NORTHBOUND DEFAULT ROLE NONE;

GRANT CREATE SESSION TO NORTHBOUND;

GRANT SELECT ON "DNINMSV31"."V_DNDEVICE" TO NORTHBOUND;

GRANT SELECT ON "DNINMSV31"."V_DNSUBNE" TO NORTHBOUND;

GRANT SELECT ON "DNINMSV31"."V_DNPACKAGE" TO NORTHBOUND;

GRANT SELECT ON "DNINMSV31"."V_DNPORT" TO NORTHBOUND;

注：在用NORTHBOUND登录后查询的时候要在视图前加上DNINMSV31，否则会报表或视图不存在。

例如：

select * from DNINMSV31.V_DNDEVICE;     --可以正常执行

select * from DNINMSV31.TB_DEVICE where rownum<5;   --执行的时候会报表或视图不存在

GRANT debug any procedure, debug connect session TO hnckb;

grant select on sys.dba_pending_transactions to hnckb;

grant CREATE VIEW,CREATE JOB,CREATE SYNONYM to hnckb;

grant CONNECT,RESOURCE to hnckb;

1.标准角色

CONNECT

RESOURCE

2.系统权限

CREATE VIEW

CREATE DATABASE LINK

CREATE JOB

CREATE SYNONYM

UNLIMITED TABLESPACE

更改定额

命令：ALTER USER 名称 QUOTA 0 ON 表空间名

ALT