已创建用户OFFICESYS,怎么样在odbc设置,使其登陆后,能在程序中调用用户OFFICESYS的表和视图等数据库对象
-- 创建用户
CREATE USER OFFICESYS
IDENTIFIED BY OFFICESYS
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
-- 设置角色权限
GRANT CONNECT TO OFFICESYS;
GRANT RESOURCE TO OFFICESYS;
-- 设置系统权限
GRANT UNLIMITED TABLESPACE TO OFFICESYS;
-- 创建用户
CREATE USER OFFICESYS
IDENTIFIED BY OFFICESYS
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP;
-- 设置角色权限
GRANT CONNECT TO OFFICESYS;
GRANT RESOURCE TO OFFICESYS;
-- 设置系统权限
GRANT UNLIMITED TABLESPACE TO OFFICESYS;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货