Recognizing Roles
In multiuser RDBMSs, each database is controlled or owned by a specified user, charged with certain responsibilities, and bestowed with certain rights. These rights and responsibilities vary widely among database management systems, but they often include
Setting up permissions for other users within the database
Making backup copies of the database on a regular basis and running the recovery procedures in case of system failure
Enlarging the database if more space becomes necessary
Owning most of the production database objects
Understanding the kind of data that is in the database and how it is used
In most database system installations, only the system administrator worries about physical storage. Users who issue the SQL commands ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth 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.