oracle--table, user, authorization

1, in order to avoid errors, the best, in the newly created tablespace, user name and password, and the original user name and password are a
Kind of, so save a lot of trouble.
Part fifth: Some common commands
1. Table operation
See which tables the current user has:
SELECT * from tab;
Select table_name from User_tables; The current user's table
Select table_name from All_tables; All users ' tables
Select table_name from Dba_tables; including system tables
To view the table structure of a table:
DESC table_name;
2. User operation
View All Users: SELECT * from All_users;
View the role of the current user select * from User_role_privs;
View system permissions for the current user select * from User_sys_privs
View system permissions for the current role select * from Role_sys_privs
3.
SELECT * from All_tab_privs; --------View the Actionable table permissions for the user you are using
SELECT * from User_tab_privs; --------View Table-operable permissions for the current user
To create a new user:
Create user ABC identified by ABC
Default Tablespace MySpace
Temporary tablespace myspacetemp;
Delete users: Drop user user_name cascade;
Authorization for User: Grant Connect,resource to user_name;
Cancel the user's authorization: Revoke Connect,resource from user_name;
Modify user password: Alter users user_name identified by USER_PWD;

oracle--table, user, authorization