Recent content by rutherford

  1. R

    Not able to view triggers from non-owner schema

    For what it's worth, we were running a 10.2.0.1 database; after upgrading to 10.2.0.5 objects given "grant debug" show up in all_objects as expected making this no longer an issue.
  2. R

    Not able to view triggers from non-owner schema

    No, the triggers are not listed in all_objects. However, you can find their source in all_source and their metadata in all_triggers. Is it possible for PL/SQL Developer to key off all_source for functions/packages/etc to handle the DEBUG grant, or is the only solution to get access to the DBA...
  3. R

    Not able to view triggers from non-owner schema

    In version 9.0.2.1621 of PL/SQL Developer I am not able to view triggers from non-owner schemas. Steps to reproduce - 1. Create table and trigger in schema A 2. Grant DEBUG on table to schema B 3. Confirm trigger is visible in all_triggers from schema B (select * from all_triggers where owner...
  4. R

    Table comments missing with "edit" of VIEW in database

    When you right click a view and choose "edit" you get the view source and column comments DDL statements, but table comments (comment on table myview IS 'foo';) are not present in the listing. I am using version 8.0.4.1514; is this feature scheduled to be added in the beta for the next major...
See more
Back
Top