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 vote138 views1 answer
Geopoint from json mysql function
SQL
3 votes142 views2 answers
How to delete git repo locally
SQL
0 vote142 views1 answer
Sqlserver now
SQL
0 vote160 views1 answer
Sql date with year
SQL
14 votes127 views3 answers
How to add default constraint in mysql
SQL
1 vote133 views1 answer
Spark sql concatenate string and int
SQL
1 vote129 views1 answer
How to open closed port mysql in ubuntu
SQL
2 votes149 views3 answers
Sql server reseed identity column
SQL
0 vote129 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote129 views1 answer
Sql missing values
SQL