Personal Oracle and Security

Oracle implements security by using three basic constructs:

  • Users

  • Roles

  • Privileges

MySQL utilizes Users and Privileges.

Creating Users

Users are account names that are allowed to log on to the Oracle database. The Oracle SQL syntax used to create a new user is as follows:

CREATE USER user
IDENTIFIED {BY password | EXTERNALLY}
[DEFAULT TABLESPACE tablespace]
[TEMPORARY TABLESPACE tablespace]
[QUOTA {integer [K|M] | UNLIMITED} ON tablespace]
[PROFILE profile]

If the BY password option is chosen, the system prompts the user to enter a password each time he or she logs on. As an example, create a username for yourself: ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with O’Reilly online learning.

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