Patent · US Active

Pluggable database lockdown profile

US10733316B2 · kind B2 · utility

1Cited by
4References
31Claims
0Family size

Assignee

Inventors

Key dates

Filing dateAug 23, 2016
Grant dateAug 4, 2020
Priority date
Expiry dateMar 15, 2038

Classification

  • Technology area (CPC G)Physics
  • CPC primaryG06F21/62
  • WIPO fieldComputer technology
  • WIPO sectorElectrical engineering

Abstract

Techniques are described herein for allowing a container DBMS to impose restrictions, on a per-pluggable-database basis, on operations based on the pluggable database to which the users that request the operations belong. In one embodiment, lockdown profiles can be created and mapped to pluggable databases. Lockdown profiles specify PDB-wide restrictions on operations. The restrictions may apply to all operations of a given type, may apply to specific features, may require use of specific parameter values, etc. All users that belong to a pluggable database are restricted by the restrictions specified in the lockdown profile to which their pluggable database is mapped, unless the lockdown profile has a user-specific exemption for them. Bitmaps and/or hash tables may be used to more quickly determine, at query runtime, whether a query violates any profile-specified restrictions. Execution of queries that violate any profile-specified restrictions is prevented.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.