79445619

Date: 2025-02-17 14:05:05
Score: 1.5
Natty:
Report link

Note that it's now possible with Oracle 23c, using what's called Schema-level Privileges and the "GRANT SELECT ANY TABLE on SCHEMA" instruction.

See Oracle blog entry "Schema-level privilege grants with Database 23ai"

Example of this instruction in Oracle 23c (or later) could be :

GRANT SELECT ANY TABLE ON SCHEMA HR TO SCOTT;

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: R. Du