我希望能够在Oracle中编写一行代码,以便可以一次性将表的选择权限授予多个模式。以下是我拥有的内容,但我遇到了语法错误:
GRANT SELECT ON OWNER.TABLE_NAME to (select distinct owner from dba_objects where owner like 'SCHEMA_%');