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 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.

Start your free trial