授予选择，插入，更新表空间的权限

GRANT USE OF TABLESPACE MYTABLESPACE TO USERNAME

declare
  l_SQL varchar2(4000);
begin
  for cur in (
    select * from dba_tables where tablespace_name = \'mytablespace\')
  loop
    l_sql := \'grant select, insert, update on \' || cur.owner || \'.\' || cur.table_name || \' to myuser\';
    --dbms_output.put_line(l_SQL || \';\');
    execute immediate l_SQL;
  end loop;
end;

USE OF TABLESPACE

alter user username quota [amount] on mytablespace;

grant

grant select, insert, update, delete on mytable1 to username;
....