However, running the same query for synonyms owned by APPS returns 19647 records - this is the number of views and tables that the existing change has added to the Table and View nodes.Īnother problem with adding public synonyms would be the potential for duplicate names as it is possible to have a private synonym with the same name as a public synonym, which could even be for a different object. I am on an eBusiness Suite site and the public synonyms for views and tables query returns 5768 records for our APPS user. If you select the synonym in the tables node, you'll see the table definition and the data grid and the data. Now if you select the Synonym in the synonyms node, you'll see the synonym definition. (Now HR can only see these tables through his Other Users node) So, HR creates a synonym for the OE.CUSTOMERS table.
Browse synonym update#
OE grants HR select, update on CUSTOMERS. You can query the data and details as if it were a table in your schema.
BUT, if a synonym has been created for that table, the synonym will appear in two places in your table list and in your synonym list.Įffectively if you have a synonym EMP for the SCOTT.EMP table, it will appears as EMP in your table list. You'll navigate to that other user and then find the table and you can see the table and data. If you have been granted access to another table in another schema, you need to look at that table and query that data and the table through Other Users (as you mention).
1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.
0 kommentar(er)
