© Michelle Malcher and Darl Kuhn 2019
Michelle Malcher and Darl KuhnPro Oracle Database 18c Administrationhttps://doi.org/10.1007/978-1-4842-4424-1_10

10. Data Dictionary Fundamentals

Michelle Malcher1  and Darl Kuhn2
(1)
Huntley, IL, USA
(2)
Morrison, CO, USA
 
The previous chapters in this book focused on topics such as creating a database, strategically implementing tablespaces, managing users, basic security, tables, indexes, and constraints. In those chapters, you were presented with several SQL queries, which accessed the data dictionary views in order to
  • Show what users are in the database and if any of their passwords expired

  • Display the owners of each table and associated privileges

  • Show the settings of various database parameters

  • Determine which ...

Get Pro Oracle Database 18c Administration: Manage and Safeguard Your Organization’s Data now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.