Oracle多实例多用户。操作其他数据库权限

 

--授权
grant insert any table to db1;

GRANT CREATE ANY SEQUENCE TO db1;

GRANT select ANY SEQUENCE TO db1;

grant select any table to db1;

--撤销权限
revoke  insert any table from  db1;

revoke  CREATE ANY SEQUENCE from db1;

revoke  select ANY SEQUENCE from db1;

revoke  select any table from db1;