我用户“zhang”(具有sysDBA权限)建了几个表(friend,other,family),然好我又建了一个用户“u1”然后我给他赋如下权限
create user u1 identified by p123GRANT CREATE SESSION TO U1
GRANT ALTER ANY TABLE TO u1;
GRANT CREATE ANY TABLE TO u1;
GRANT DELETE ANY TABLE TO u1;
GRANT DROP ANY TABLE TO u1;
GRANT SELECT ANY TABLE TO u1;
然后我用 u1/p123登陆到SQLplus,然后select* from friend
什么提示我说friend表不存在?????
create user u1 identified by p123GRANT CREATE SESSION TO U1
GRANT ALTER ANY TABLE TO u1;
GRANT CREATE ANY TABLE TO u1;
GRANT DELETE ANY TABLE TO u1;
GRANT DROP ANY TABLE TO u1;
GRANT SELECT ANY TABLE TO u1;
然后我用 u1/p123登陆到SQLplus,然后select* from friend
什么提示我说friend表不存在?????
要么
select* from zhang.friend
要么给friend建同义词才能这样用
这样建好同义词后
用其它用户登录就可以直接
select* from friend
为什么执行select* from zhang.friend 会提示权限不足呢?
======================================================
应该不需要啊。DDL 命令是隐式提交的。