Kbase P11135: How to tell who is the owner of a table in a Progress database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to tell who is the owner of a table in a Progress database?
FACT(s) (Environment):
Progress 9.1x
FIX:
To get a list of all the database tables and their owners, run the following queries:
From SQL Explorer:
SELECT "_file-name", "_owner", "_creator" FROM PUB."_file";
From the Progress Procedure Editor
SELECT _file-name, _owner, _creator FROM _file