0
I have an Oracle server that has several schema, for the purpose of explanation, understand the metaphor:
There are schema classified as LETTERS, and schema classified as NUMERIC, and several times need to change the synonyms between LETTERS and NUMBERS.
All LETTERS can have Grants of NUMBERS, but not the NUMBERS, or LETTERS may know which objects are in the NUMBERS.
Example: The schema ONE, TWO, THREE HAS grants to the schema A. So I create a private synonyms in the schema To:
create or replace synonym TABELA1 for UM.TABELA1;
This way when doing a query in schema A:
select * from tabela1;
I’ll have feedback from schema ONE Tabela1.
Problem: I have a schema manager, and I need to know which schema was made the last synonyms change.
I tried to use:
user_objects: It has some date and time data, but it’s no good.
user_tables: You have data from the time of analysis.
USER_DEPENDENCIES: nothingness
ALL_SOURCE: nothingness
TRIED SELECT Last_ddl_time FROM USER_OBJECTS ?
– Motta
@Motta, I tried yes, this date is from when it was created, even putting
create or replacethis date is not changed if you modify thesynonymonly by creating, thus not serving my purpose :/– David
in the doc is "LAST_DDL_TIME DATE NOT NULL Timestamp for the last modification of the Object Resulting from a DDL statement (including Grants and revokes)"
– Motta