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 vote115 views1 answer
Print hello world in plsql
SQL
0 vote115 views1 answer
Group by max date
SQL
-2 votes110 views1 answer
No module named '_sqlite3
SQL
0 vote95 views1 answer
Mysql drop multiple tables at once
SQL
13 votes107 views2 answers
Sqlite rename table
SQL
0 vote117 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote114 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote92 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote101 views1 answer
Sql case when exists in another table
SQL
0 vote102 views2 answers
Transaction php
SQL