Database Management: Users, Privileges, Roles, Profiles, Tablespaces
Classified in Arts and Humanities
Written on in
English with a size of 7.63 KB
Database User Management
Creating and Modifying Users
Use the CREATE USER or ALTER USER command to manage user accounts, defining their authentication, default storage, resource limits, and account status:
CREATE/ALTER USER username IDENTIFIED BY password
[DEFAULT TABLESPACE tablespace_name]
[TEMPORARY TABLESPACE tablespace_name]
[QUOTA {integer {K|M} | UNLIMITED} ON tablespace_name]
[PROFILE profile_name]
[ACCOUNT {LOCK|UNLOCK}];Dropping Users
To remove a user and all their associated schema objects, use the DROP USER command with the CASCADE option:
DROP USER user_name CASCADE;Database Privilege Management
Granting Object and System Privileges
The GRANT command assigns specific object or system privileges to users or roles:
GRANT SELECT ANY TABLE... Continue reading "Database Management: Users, Privileges, Roles, Profiles, Tablespaces" »