Rules tagged with: Pattern

Common programming patterns.

• G-1110 Avoid connect users that own database objects.

  Security
• G-1120 Avoid granting system privileges to connect users.

  Security
• G-1130 Avoid granting table access to API roles.

  Maintainability
• G-1140 Avoid granting object privileges directly to connect users.

  Maintainability
• G-1150 Always limit privileges of schema owners according to principle of least privileges.

  Security
• G-8110 Never use SELECT COUNT(*) if you are only interested in the existence of a row.

  Reliability
• G-8120 Never check existence of a row to decide whether to create it or not.

  Reliability
• G-8210 Always use synonyms when accessing objects of another application schema.

  Maintainability
• G-8310 Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.

  Maintainability
• G-8410 Always use application locks to ensure a program unit is only running once at a given time.

  Reliability
• G-8510 Always use dbms_application_info to track program process transiently.

  Reliability

11 total