View Table form - Trigger and Privilege data dictionary

[akaya]

Hello,

Which view does PLSQL Developer query when fetching information about Triggers and Privileges of a Table?

We are trying to see details of schema1.table1 when logged on as schema2 and it does not show the privileges and triggers.

Best regards.

 

[Claus Pedersen]

To investigate the SQL code that PL/SQL Developer generates to query the data dictionary views in the database, you can modify the shortcut to PLD by adding the debugsql parameter:
"C:\Program Files\PLSQL Developer 12\plsqldev.exe" debugsql

Then you can investigate the debug.txt file created in the %appdata%\PLSQL Developer 12 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 12)

Remember to remove the debugsql parameter after you are finished investigating, otherwise it can be time consuming for PLD to keep writing the file.

Ask if you have more questions.

 

[akaya]

Thank you. For version 10.0.5, debug.txt was created in C:\Program Files (x86)\PLSQL Developer

I was able to see that it uses sys.all_triggers and sys.all_tab_privs.