Cross schema query oracle 2 users

-- Most likely, you need your DBA to grant user A access to whatever tables in the PCT schema that you need. Something like:
GRANT SELECT ON pct.pi_int TO a;

Source: stackoverflow.com

Similar codes

0 vote159 views1 answer
Alter check command
SQL
5 votes165 views1 answer
How to check port number for postgresql
SQL
13 votes207 views3 answers
Mysqldump structure only
SQL
0 vote155 views1 answer
Kill slow queries mysql
SQL
2 votes144 views1 answer
Oracle drop table free up space
SQL
3 votes268 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
2 votes165 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote147 views2 answers
Auto increment column in mysql query results
SQL
0 vote153 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote141 views1 answer
Sql datediff db2
SQL