Oracle创建用户并给用户授权查询指定表或视图的权限
MSV31账户登录数据库进行如下操作:
CREATE USER NORTHBOUND IDENTIFIED BY NORTHBOUND
DEFAULT TABLESPACE "TBS_DNINMSV31"
TEMPORARY TABLESPACE "TEMP2"
QUOTA UNLIMITED ON "TBS_DNINMSV31";
GRANT "CONNECT" TO NORTH
转载
2017-04-17 16:37:10 ·
1618 阅读 ·
0 评论