Logon as a and generate the script using,
select 'grant select,update,delete, insert on '||table_name||' to b;'
from USER_TABLES;
now run this script while logged on as a.
Better create role and grant these permissions to role and then grant this role to user b or anyone else as required.




Reply With Quote