Oracle creates tablespaces, creates users, and grants and views Permissions

Create temporary tablespace test_temptempfile 'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl \ test_temp01.dbf' size 32 mautoextend onnext 32 m maxsize 2048 mextent management local; create user tablespace create tablespace test_dataloggingdatafile 'C: \ oracle \ product \ 10.1.0 \ oradata \ orcl \ test_data01.dbf' size 32 m autoextend on next 32 m maxsize 2048 mextent management local; create User Username identified by passworddefault tablespace test_datatemporary tablespace test_temp; grant the user the permission to grant create session, create any table, create any view, create any index, create any procedure, alter any table, alter any procedure, drop any table, drop any view, drop any index, drop any procedure, select any table, insert any table, update any table, delete any table to username; grant the role "role" to username, that is, enable the user "username" to manage and use the resources owned by role "Grant role to username; revoke view User Permissions revoke view all users select * From dba_users; select * From all_users; select * From user_users; view user system permissions select * From dba_sys_privs; select * From user_sys_privs; view user objects or role permissions select * From dba_tab_privs; select * From all_tab_privs; select * From user_tab_privs; view all roles select * From dba_roles; view the select * From dba_role_privs; select * From user_role_privs;