Kbase 13016: How to show what ORACLE user owns the table in PROGRESS
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/23/2003 |
|
Status: Unverified
GOAL:
How to identify the foreign owner of an ORACLE table through the 4GL?
GOAL:
Find the foreign owner of a table within ORACLE
FACT(s) (Environment):
Oracle DataServer
FIX:
The important fields within _File that show this information are;
_For-name
_For-owner
The following code will display the owner and table name that the schema holder holds:
FOR EACH _db WHERE _db-type = "ORACLE":
FOR EACH _file of _db:
DISPLAY _for-name _for-owner.
END.
END.
** You may change the query to filter a specific table.