Creating users under a specific tables in oracle

So i am supposed to create Two users for Customer Service department and one user for the Inventory department.

Below is the code for one of the users i was creating for customer service department but dont know how to place the user under Customer Service department. The Customer Service Department is a table that is already in the database

CREATE USER Patricia  IDENTIFIED BY Patricia001  DEFAULT TABLESPACE extra_tbs  DEFAULT TEMPORARY TABLESPACE Temp  QUOTA UNLIMITED ON extra_tbs  PROFILE Secretary   PASSWORD EXPIRE  GRANT CREATE SESSION  ACCOUNT UNLOCK  LIMIT   FAILED_LOGIN_ATTEMPTS 3   PASSWORD_LOCK_TIME 1  PASSWORD_LIFE_TIME 60  IDLE_TIME 10;  

https://stackoverflow.com/questions/66739033/creating-users-under-a-specific-tables-in-oracle March 22, 2021 at 08:43AM