user

These commands are typically used by database administrators (DBAs) to manage users, permissions, and roles in the database.

Create a New User

CREATE USER "zhamri" IDENTIFIED BY "zhamri123";

Grant Privileges to a User

1. Grant System Privileges (e.g., creating tables, sessions):

GRANT CREATE SESSION TO "zhamri"; -- Allows user to log in
GRANT CREATE TABLE TO "zhamri";   -- Allows user to create tables

2. Grant Object Privileges (e.g., access to specific tables):

GRANT SELECT, INSERT, UPDATE ON "d1_student_realtime" TO "zhamri";

3. Grant Role (e.g., DBA role for full privileges):

GRANT DBA TO "zhamri";

Change a User’s Password

Lock or Unlock a User Account

Drop (Delete) a User

View All Users

Check the Current User

Alter User to Grant or Revoke Quota on Tablespaces

Change User’s Default Tablespace and Temporary Tablespace

Check User Privileges

Revoke Privileges from a User

REVOKE privilege FROM username;

REVOKE CREATE TABLE FROM username;