PL/SQL (MOSC)

MOSC Banner

Security Model Using Invoker's Rights

edited May 21, 2020 12:03PM in PL/SQL (MOSC) 3 commentsAnswered ✓

Oracle RDBMS 12.2.0.1.0

We are starting a new development project and perhaps now is the time for a security model change.  Development came to me for a READ account and a WRITE account.  Access to the database is through PL/SQL Packages.  That's a little unclear, so was thinking about adding something to their request.

DATA OWNER, CODE OWNER:   PERMIT

PERMIT will own the objects and create its procedures with authid current_user to use Invoker's rights.

PERMIT grants execute to PERMIT READ and the required SELECT privs on objects

PERMIT grants execute to PERMIT_WRITE and the required S,I,U,D privs on objects

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center