Oracle创建用户并给用户授权查询指定表或视图的权限
MSV31账户登录数据库进行如下操作： CREATE USERNORTHBOUND IDENTIFIED BYNORTHBOUND DEFAULT TABLESPACE TBS_DNINMSV31 TEMPORARY TABLESPACE TEMP2 QUOTA UNLIMITED ON TBS_DNINMSV31; GRANT CONNECT TONORTHBOUND
MSV31账户登录数据库进行如下操作： CREATE USERNORTHBOUND IDENTIFIED BYNORTHBOUND DEFAULT TABLESPACE TBS_DNINMSV31 TEMPORARY TABLESPACE TEMP2 QUOTA UNLIMITED ON TBS_DNINMSV31; GRANT CONNECT TONORTHBOUND