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

7.3. Analyzing the Library System's Requirements

Now that we've seen some of what Oracle has to offer, we can revisit the first security requirement of the electronic catalog. The first item says:

The creation, maintenance, and revocation of patron accounts in the electronic catalog will be allowed, including issuance of some sort of credentials such as a user account or library card.

If we do our job right, implementing this requirement will go a long way toward satisfying the next two requirements:

There will be security checks in place that make it difficult for a patron to view information about another patron's borrowing habits.

A privileged system administrator will be able to create accounts for librarians, who in turn will have authority to grant and revoke patron privileges.

I'd like to start by considering how to secure each patron's account.

7.3.1. Patron Accounts

We could, of course, set up a system whereby each library patron has an Oracle account, allowing us to use Oracle's built-in security features. However, there are some problems with this approach. The biggest is that there are potentially thousands and thousands of users, and it is sort of impractical to manage Oracle accounts for people who may log in only once. In addition, I've heard that at least some versions of Oracle have performance problems when the number of accounts gets into hundreds of thousands.

If we're not going to put the patrons' accounts into Oracle's native authentication mechanism, ...

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