Kbase 19436: SQL89 - How to determine owner of a view
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/20/2000 |
|
KnowledgeBase Number: 19436
Creation Date: 20-JAN-00
Modified Date:
This document applies to: Progress SQL89
Version and Release Number: Version 7,8
Summary: In SQL92 owner of a view as well as user with DBA privileges can drop the view but in SQL89 only owner of a view can drop the view. Following are the steps that would help to find out who would be the owner of a view.
Step by Step Details:
From Unix:
1. Bring up the Data Dictionary screen.
2. Select 'PRO/SQL view report'from 'PRO/SQL' menu
It gives you a list of views to select.
3. Select the desired view.
A report is created with the information regarding who can read, can write, can create and can delete. The first name listed in those privileges is always the owner.
From Windows:
1. Bring up the Data Dictionary screen.
2. Select 'Reports' from 'Database' menu.
3. Select 'PRO/SQL view'.
4. Select the desired view.
A report is created with the information regarding who can read, can write, can create and can delete. The first name listed in those privileges is always the owner.