SELECT - Oracle Help Center

Additional Topics Prerequisites Syntax Semantics Examples Prerequisites For you to select data from a table or materialized view, the table or materialized view must be in your own schema or you must have the SELECT privilege on the table or materialized

docs.oracle.com