cross schema query oracle 2 users
Solutions on MaxInterview for cross schema query oracle 2 users by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "cross schema query oracle 2 users"
Aidan
19 Apr 2017
1-- Most likely, you need your DBA to grant user A access to whatever tables in the PCT schema that you need. Something like:
2GRANT SELECT ON pct.pi_int TO a;similar questions
create schema oracle sql 19coracle get current schemaoracle all tables in schemaquery saurce oracleoracle get table schemaoracle trigger after logon on schemaoracle role useroracle create schemaoracle query to find schema you are working onoracle user tableshow to check schema privileges in oracleoracle compile schemaoracle compile whole schemaoracle list user defined typesselect dba users oracleoracle list columns in schemaoracle list columns schemaoracle locked objectsoracle privileges usersoracle grant on all tables in schemaoracle query to see what scema i am working inoracle grant select on schema your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful