grant select on tablename to username; -------这个对某个表进行查询的权限grant select any table to username; -------对整个数据库所有的表具有查询的权限
1、建用户 create user user_name identified by password default tablespace tablespace_name temporary tablespace tmptablespace_name; 2、赋权 grant connect,select any table to user_name;
create user user_name identified by password default tablespace tablespace_name temporary tablespace tmptablespace_name;
2、赋权
grant connect,select any table to user_name;