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 vote318 views1 answer
Oracle sql winter time change
SQL
0 vote354 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote322 views1 answer
Oracle synonym procedure dblink
SQL
24 votes323 views2 answers
Alter table delete column
SQL
0 vote334 views1 answer
Add computed column to table sql server
SQL
0 vote331 views1 answer
How to put value in parameters in mysqldataadapter
SQL
5 votes330 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
2 votes395 views2 answers
MySql FULL OUTER JOIN
SQL
50 votes409 views6 answers
Install mysql on ubuntu
SQL
0 vote330 views1 answer
How to print mysql query of codeigniter query builder
SQL