Kbase P4569: How to determine who created a particular SQL92 VIEW ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
How to determine who created a particular SQL92 VIEW ?
GOAL:
Who is the owner of a SQL-92 View?
FACT(s) (Environment):
Progress 9.1x
MERANT 3.60 32-BIT Progress SQL-92
DataDirect 4.1 32-Bit Progress SQL92 9.1D
FIX:
There are two methods:
1) Use a SQL statement to query the sysprogress.systables table to see who
created the SQL-92 VIEW.
Example:
SELECT tbl, creator, owner FROM SYSPROGRESS.SYSTABLES
where tbl= 'viewname'
2) Use a 3rd party tool, such as WinSQL, that are capable of displaying properties of all database objects (tables, views, etc).