Creating User Accounts
Before the database can be used, a user account must be created and be granted privileges. Examples of privileges are the ability to establish an Oracle session, the ability to create database objects (e.g., tables, synonyms), or the ability to modify data that another user account owns. User accounts are also used to denote the owner of a database object.
When Oracle is first installed, two default accounts are created: SYS and SYSTEM. If you have just installed Oracle, you will be interested in the SYSTEM account, the default ID for which is manager. This is an account that has the privileges to create other user accounts and to create many of the needed database objects. This account also has the ability to grant and ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts 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.
