Skip to Main Content
Learning Oracle PL/SQL
book

Learning Oracle PL/SQL

by Bill Pribyl, Steven Feuerstein
November 2001
Beginner content levelBeginner
424 pages
11h 11m
English
O'Reilly Media, Inc.
Content preview from Learning Oracle PL/SQL

9.6. Managing Patron and Librarian Privileges

Back in Chapter 7, we looked at Oracle security and how we could protect the security of our library application. One important component of application security involves specifying and managing privileges. This section provides the detailed information about how to set up the necessary privileges to protect the library application.

Table 9-3 presents an overview of the software components we will add to the library system in order to allow individuals to have their own password-protected accounts.

Table 9-3. PL/SQL components involved in security for the library system
Category Task Program name Implemented where?
Login-related user interface components User interface for logging in and out
login
Stored procedure (PL/SQL Server Page)
  Support utilities for login PSP
process_login
logout
Package loginweb
  Administrator create and modify any user page
userform
Stored procedure (PL/SQL Server Page)
  Support utilities for userform PSP
process_edits
Package userformweb
  End user modify profile page
editprof
Stored procedure (PL/SQL Server Page)
Administer user security for web applications (using session ids) If username and password okay, create new session id (random string)
new_session_id
Package privweb (privilege for web applications)
  Find user id from session id
user_id
 
  Determine whether session has a particular privilege
assert_allowed
 
Administer user security based on user ids Determine whether ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Learning Oracle PL/SQL

Learning Oracle PL/SQL

Darryl Hurley
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl

Publisher Resources

ISBN: 0596001800Supplemental ContentCatalog PageErrata