Users, Roles and Security

Security is a core strength of Oracle Database. Oracle provides a comprehensive security model that includes authentication, authorisation, encryption, auditing, and fine-grained access control. This lesson covers the essential security features every Oracle professional should know.

---

Users and Schemas

In Oracle, a user and a schema are closely related:

• A user is an account that can connect to the database
• A schema is the collection of objects (tables, views, etc.) owned by that user
• When you create a user, a schema of the same name is automatically created

-- Create a user
CREATE USER app_user IDENTIFIED BY SecurePass123
  DEFAULT TABLESPACE users
  TEMPORARY TABLESPACE temp
  QUOTA 500M ON users;

-- Change a password
ALTER USER app_user IDENTIFIED BY NewSecurePass456;

-- Lock/unlock an account
ALTER USER app_user ACCOUNT LOCK;
ALTER USER app_user ACCOUNT UNLOCK;

-- Drop a user and all their objects
DROP USER app_user CASCADE;

---

Authentication Methods