12. Users and Access Rights
For many network and database administrators, security has become an almost overwhelming concern. Relational DBMSs have always had some measure of security separate from that provided by networks. In this chapter we will look at some examples of managing database user accounts as well as SQL's support for granting and revoking access rights.
Managing User Accounts
Many multiuser DBMSs maintain user names and passwords that are distinct from any authentication that may be imposed by a network. A user must supply the DBMS's authentication information before being allowed to connect to the database.
Most DBMSs are shipped with only one or two authorized users (often DBA, SYSTEM, and/or ADMIN) that have access to the entire ...
Get SQL Clearly Explained, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
