Code Library - Oracle Live SQL

Skip to Main Content

Script
Restricting Access to a Stored Procedure

This example shows a package procedure private_proc that can only be called by top_trusted_proc proc...

LNPLS ACCESSIBLE BY Clause

0 25

8.8 years ago Sarah Hirschfeld (Oracle)
Script
Restricting Access to Top-Level Procedures in the Same Schema

This example shows that the top-level procedure top_protected_proc can only be called by procedure t...

LNPLS ACCESSIBLE BY Clause PLS-00904

0 21

8.8 years ago Sarah Hirschfeld (Oracle)
Script
12.2: Enhanced ACCESSIBLE BY Options

The ACCESSIBLE BY clause restricts access to units and subprograms by other units. The accessor list...

whitelist,accessible by

2 20

8.7 years ago Steven Feuerstein
Script
Restricting Access to a Unit Name of Any Kind

This example shows that if the PL/SQL unit_kind is not specified in the ACCESSIBLE BY clause, then a...

LNPLS ACCESSIBLE BY Clause

0 17

8.8 years ago Sarah Hirschfeld (Oracle)
Script
Use ACCESSIBLE BY to Control Access to Code

You might implement a database application as several PL/SQL packages—one package that provides the ...

ACCESSIBLE BY

0 16

9.9 years ago Steven Feuerstein
Script
accessed_by_pipelined_error

Small demo on issue with pipelined functions in packages with ACCESSIBLE BY clause.

accessible_by, pipelined

1 1

8.5 years ago Artjoms

row(s) 1 - 6 of 6