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

This article mainly introduces how to create new tablespaces, users and authorizations in the database. The article is very detailed and has certain reference value. Interested friends must read it!

1. Location table space data file save path

select file_name from dba_data_files;

2. Create table space

create bigfile tablespace xxx datafile 'datafiledir/xxx01.dbf' size 200m autoextend on;

3. Create users

create user xxx identified by password default tablespace xxx quota unlimited on xxx;

4. Authorize users

grant create trigger,create table,create sequence,create session,create public synonym,create view,drop public synonym,create procedure to xxx;

---If the user's object needs to be imported through imp, the following permissions need to be granted

grant imp_full_database to xxx;

The above is "how to create new tablespaces, users and authorization in the database" all the contents of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

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.