我新建用户zhang/zhang
create user zhang identified by zhang
然后授权
grant create session to zhang
grant unlimited tablespace to zhang
grant creat table to zhang然后换的用户zhang下
conn zhang/zhang
执行select * from scott.emp;
提示table or view does not exist。这是怎么回事?
用sys用户查询时可以查到数据。。
create user zhang identified by zhang
然后授权
grant create session to zhang
grant unlimited tablespace to zhang
grant creat table to zhang然后换的用户zhang下
conn zhang/zhang
执行select * from scott.emp;
提示table or view does not exist。这是怎么回事?
用sys用户查询时可以查到数据。。
zhang用户权限不够,你给他赋予dba的权限,就可以查了吧!
grant select any table to zhang ;