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

2 votes367 views2 answers
Mysql on duplicate key update get value from values
SQL
10 votes353 views2 answers
Mysql drop database if exists
SQL
0 vote325 views1 answer
Sql server bool select
SQL
0 vote339 views1 answer
Mysql error 1251
SQL
2 votes326 views1 answer
How to get weekday from old date in sql
SQL
0 vote354 views1 answer
Sqlite woth cmake
SQL
0 vote330 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
1 vote319 views1 answer
Oracle apex prevent initial load
SQL
4 votes358 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote324 views1 answer
How to set all the min and sec data to zero in sql server
SQL