Rules tagged with: Pattern
Common programming patterns.
All 11 check SQL or PL/SQL code (G- codes). Browse the rules below for explanations, examples and recommended fixes.
Most severe Pattern rules
- G-1110 Avoid connect users that own database objects. Blocker
- G-1120 Avoid granting system privileges to connect users. Blocker
- G-1150 Always limit privileges of schema owners according to principle of least privileges. Blocker
- G-8410 Always use application locks to ensure a program unit is only running once at a given time. Blocker
- G-1130 Avoid granting table access to API roles. Critical
- G-8110 Never use SELECT COUNT(*) if you are only interested in the existence of a row. Critical
All 11 Pattern rules
-
G-1110 Avoid connect users that own database objects.Blocker Security
-
G-1120 Avoid granting system privileges to connect users.Blocker Security
-
G-1130 Avoid granting table access to API roles.Critical Maintainability
-
G-1140 Avoid granting object privileges directly to connect users.Minor Maintainability
-
G-1150 Always limit privileges of schema owners according to principle of least privileges.Blocker Security
-
G-8110 Never use SELECT COUNT(*) if you are only interested in the existence of a row.Critical Reliability
-
G-8120 Never check existence of a row to decide whether to create it or not.Critical Reliability
-
G-8210 Always use synonyms when accessing objects of another application schema.Minor Maintainability
-
G-8310 Always validate input parameter size by assigning the parameter to a size limited variable in the declaration section of program unit.Minor Maintainability
-
G-8410 Always use application locks to ensure a program unit is only running once at a given time.Blocker Reliability
-
G-8510 Always use dbms_application_info to track program process transiently.Critical Reliability
11 total
Related tags
Tags that appear on the same rules as Pattern:
- PinkDB (5 shared)
- Performance (3 shared)
- Observability (1 shared)
More ways to browse rules
- Trivadis PL/SQL & SQL guideline rules - Rules that implement the Trivadis coding guidelines.
- OWASP-related security rules - Rules that name an OWASP Top 10 risk category.
- Oracle APEX rules - Checks for APEX applications, pages, items and regions.
- PostgreSQL rules - Rules that also apply to PostgreSQL and PL/pgSQL.
- Security rules - All rules in the Security quality area.
- Reliability rules - Rules that prevent bugs and failures at run time.
- Maintainability rules - Rules for code that is easy to read and change.
- Rules by quality area - Security, reliability and maintainability.
- Rules by severity - From Blocker to Info.
- Rule profiles - Essential to Extreme: which rules are checked.
- All rules - Search and filter the complete rule set.