Shulou(Shulou.com)05/31 Report--

Editor to share with you how oracle creates tablespaces, creates users, and assigns permissions to users. I hope you will gain something after reading this article. Let's discuss it together.

-- create temporary tablespaces

Create temporary tablespace test_temp tempfile'dVULAGUP testworthy temp01.dbf' size 30m autoextend on next 30m maxsize 2000m extent management local

-- create tablespaces

Create tablespace test_data datafile'd autoextend on next maxsize unlimited extent management local 30m autoextend on next 30m maxsize unlimited extent management local

-- create users

Create user jnyd identified by jnyd default tablespace test_data temporary tablespace test_temp

-- assign permissions to users

Grant connect,resource to jnyd

After reading this article, I believe you have a certain understanding of "oracle how to create tablespaces, create users, and grant permissions to users". If you want to know more about it, welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.