全部博文
-
编辑 删除
[转载]Oracle创建用户并给用户授权查询指定表或视图的权限
原文地址：Oracle创建用户并给用户授权查询指定表或视图的权限作者：于士博 用DNINMSV31账户登录数据库进行如下操作： CREATE USER NORTHBOUND IDENTIFIEDBY NORTHBOUND DEFAULTTABLESPACE "TBS_DNINMSV31" TEMPORARY TABLESPACE "TEMP2" QUOTA UNLIMITED ON "TBS_DNINMSV31"; GRANT "CONNECT" TO NORTHBOUND; ALTER USER NORTHBOUND DEFAULT ROLENONE; GRANT CREATE SESSION TONORTHBOUND; GRANT SELECT ON "DNINMSV31"."V_DNDEVICE" TO NORTHBOUND; GRANT SELECT ON "DNINMSV31"."V_DNSUBNE" TO NORTHBOUND; GR
