How does Oracle create tablespaces, create database users, and assign permissions

This article will explain in detail how Oracle creates tablespaces, database users and permissions. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Create a tablespace:

Create tablespace HY datafile'/ usr/oracle/oradata/YSDB/HY01.dbf' size 300m autoextend on next 50m maxsize unlimited

Create temporary tablespaces:

Create TEMPORARY tablespace TMP tempfile'/ usr/oracle/oradata/YSDB/TMP01.dbf' size 1000m autoextend on next 50m maxsize unlimited

Create a database user:

Create user hy identified by hy

Default tablespace HY

Temporary tablespace TMP

Grant permissions:

GRANT CREATE ANY SYNONYM to hy

GRANT CREATE CLUSTER to hy

GRANT CREATE INDEXTYPE to hy

GRANT CREATE PROCEDURE to hy

GRANT CREATE SEQUENCE to hy

GRANT CREATE SESSION to hy

GRANT CREATE TABLE to hy

GRANT CREATE TRIGGER to hy

GRANT CREATE TYPE to hy

GRANT CREATE VIEW to hy

GRANT DROP ANY SYNONYM to hy

GRANT UNLIMITED TABLESPACE to hy

View user permissions:

Select * from dba_sys_privs where grantee = 'HY'

On "Oracle how to create tablespaces, create database users, grant permissions" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.