Rules tagged with: Pattern

Common programming patterns.

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

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

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

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

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

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

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

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

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

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

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

  Reliability

11 total