November 2001
Beginner
424 pages
11h 11m
English
Content preview from Learning Oracle PL/SQL
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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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.
| 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.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.