- 论坛徽章:
- 0
|
1 -- Create the user
create user WPDS
identified by
default tablespace SYSTEM
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke object privileges
grant select, update on SCA to WPDS;
-- Grant/Revoke role privileges
grant connect to WPDS;
grant resource to WPDS;
-- Grant/Revoke system privileges
grant select any table to WPDS;
grant update any table to WPDS;
2.用wpds登陆没有问题,sca表是system用户建的。
在执行select * from system.sca可以。但是执行select * from sca
提示:ORA-00942: table or view does not exist
我要在SQL不要system,我应该如何做?
3。创建一个synonym可以达到要求,但是如果我的表一多,这样我就得一个一个建,这样工作量大。能不能让wpds继承system用户的所有表。这样就很方便了 |
|