1.
set feedback off
set echo off
spool grant.sql
select 'grant all on ' || object_name || ' to userB' from dba_objects
where owner='userA'
spool off2.
sql>@grant.sql
set feedback off
set echo off
spool grant.sql
select 'grant all on ' || object_name || ' to userB' from dba_objects
where owner='userA'
spool off2.
sql>@grant.sql
Create user UserB identified by Password;
grant userA to userB;
grant userA to userB;这个无法执行,是不是因为我的数据库是8.0.5的现在我用的是cenlmmx(学海无涯苦作舟) 的办法
还有没有别的办法?