Oracle View user's Table space

View the current user's table space

[SQL]View Plaincopy

1. Select Username,default_tablespace from user_users;

Modify the user default table space

[SQL]View Plaincopy

1. Alter user username default tablespace new table space;

View the roles owned by the user

[SQL]View Plaincopy

1. SELECT * from user_role_privs;

How many tables are in the query database

[SQL]View Plaincopy

1. SELECT * from user_tables;
   

Oracle View user's Table space