An Analysis of Oracle tablespaces

Questions about Oracle user tablespace Permissions: User A is created under SYS. The default tablespace is A1 and the temporary tablespace is A2.

Then create table space A3. How does user A have the permission to create A table in A3? The premise is that a create any table and DBA permissions are not granted (that is, the tablespace that user A can use is A1, A2, A3 ).

After A3 is changed to SYS's default tablespace SYSTEM, is the answer feasible?

By the way, what is the use of the TABS table in oracle?

Oracle user tablespace permissions:

Question 1

You only need to allocate the a3 tablespace quota to user a. You only need to execute it under sys.

 
 

  
  
SQL>ALTER USERA QUOTA UNLIMITEDONA3;-- A users can use the a3 tablespace infinitely. 
 
 

Or

 
 

  
  
SQL>ALTER USERA quota 100 MOnA3;-- A users can use data in the 100Ma3 tablespace. 
 
 

Question 2

Tabs is a synonym for user_tables. It is created by oracle to simplify the writing of SQL statements. You only need to execute the following query in system.

 
 

  
  
select * from dba_synonyms   
  
  
where synonym_name='TABS' 
 
 

The Oracle user's tablespace permission is described here.