O'Reilly logo

OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating and managing user accounts

One of the primary security principles is authentication. Authentication is the process of confirming the identity of a user. Users access the database by way of user accounts. In order to successfully log in to a database, a user must pass through some form of authentication, often by way of a user account name and password. To review what we've learned in previous chapters, there are two major default administrative accounts in Oracle called SYS and SYSTEM. The SYS account is the highest administrative account available. It owns the data dictionary and has the power to do any type of administrative activity. The SYSTEM account is comparable in terms of authority, but does not own the data dictionary. SYSTEM ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required