Edit View functionality

[thillson]

This may be an Oracle permissions issue, but here's the question.

If I am connected to PLSQL developer as a DBA account and I attempt to edit a view I do not see the column aliases at the top of the view source. I do see these when I am directly connected as the owner of the view.

Steps to re-create:
1) as DBA account from Browser scroll to a view owned by another user.
2) Click on view name and right-click Edit
3) The source that is displayed in the right hand panel does not include the column aliases.

If you connect as the owner of the view and follow the same steps you do see the column aliases before the select statement for the view.

Any ideas why we cannot see this as the DBA?

plsql developer version 5.1.2.682
Oracle version:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.2.0 - Production

OS: Red Hat linux advanced server 2.1

 

[Marco Kalter]

If the column aliases do not reside within the SQL select statement of the view, then you must indeed be connected as the owner of the view.

------------------
Marco Kalter
Allround Automations