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

1 vote324 views1 answer
How to see logical reads in sql server
SQL
1 vote274 views1 answer
Display total number of tables in mysql
SQL
0 vote292 views1 answer
Mysql type for large numbers with many decimal
SQL
4 votes331 views3 answers
Postgres drop all tables
SQL
0 vote311 views1 answer
Postgres change the name of schema
SQL
34 votes310 views5 answers
Oracle alter table add column
SQL
0 vote357 views1 answer
Mysql get nested records
SQL
1 vote256 views1 answer
Psql show with user is logged in
SQL
0 vote290 views1 answer
Report in database
SQL
4 votes297 views2 answers
Linq join
SQL