Oracle - System Privilege to create New User and Granting system privileges to a User
System Privilege
--====================================================
01.01: Creating Users - Syntax
CREATE USER user
IDENTIFIED BY password;
01.02: Create user
CREATE USER po_user
IDENTIFIED BY 123;
02.01: After a user is created, the DBA can grant specific system privileges to that user.
GRANT
CREATE SESSION,
CREATE TABLE,
CREATE SEQUENCE,
CREATE VIEW,
CREATE PROCEDURE
TO po_user;
03. Quota Assign to an user on users tablespace
ALTER USER po_user
QUOTA 10M ON USERS;
![[MMD]YYB式萌王EX斯大林&丰臣秀吉-ELECT FPS60](https://images.videosashka.com/watch/Ci-o5RrtCB8)
