Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 19. Managing Database Security
Database security is simply the process of protecting the data from unauthorized usage. Unauthorized usage includes data access by database users who should have access to part of the database, but not all parts . This protection also includes the act of policing against unauthorized connectivity and distribution of privileges. There are many user levels in a database, from the database creator, individuals responsible for maintaining the database (such as the database administrator [DBA]), database programmers, and end users. End users, although individuals with the most limited access, are the users for which the database exists. Each user has a different level of access to the database and should be limited to the fewest number of privileges needed to perform his or her particular job.
