create user abcd identified by password123;grant connect to abcd;grant select on scott.emp to abcd; --这里实现想给他权限查询的表 grant select on scott.dept to abcd; --这里实现想给他权限查询的表
conn abcd/password123create synonym emp for scott.emp; create synonym dept for scott.dept;再建立同义词以后,你就可以看到表了,有一种本地的感觉
create user abcd identified by password123; grant connect to abcd; grant select on scott.emp to abcd; grant select on scott.dept to abcd; 同意,当然,你可以用grant all privileges on scott.emp to abcd来把对这个表的所有操作权限授予abcd;
grant select on scott.dept to abcd; --这里实现想给他权限查询的表
conn abcd/password123create synonym emp for scott.emp;
create synonym dept for scott.dept;再建立同义词以后,你就可以看到表了,有一种本地的感觉
grant select on scott.dept to abcd; 同意,当然,你可以用grant all privileges on scott.emp to abcd来把对这个表的所有操作权限授予abcd;