Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DEBUG on a table?

EdStevensFeb 19 2020 — edited Feb 19 2020

I feel embarrassed to ask this, but I've never actually had to address it before, and reading the docs was no help.

I'm reviewing the security profile (roles and privileges) of my developers, and see that they have been granted DEBUG on selected tables.  I can understand DEBUG on a procedure, but on a table?  What does this even mean?

the SQL Reference, table 18-2 says this:

OBJECT TYPE PRIVILEGES

The following object type privileges authorize operations on a database object type.

DEBUG

Access, through a debugger, all public and nonpublic variables, methods, and types defined on the object type.

Place a breakpoint or stop at a line or instruction boundary within the type body.

Comments
Post Details
Added on Feb 19 2020
2 comments
1,317 views