Oracle allows you to view users, user permissions, user tablespaces, and user default tablespaces.

Oracle allows you to view the relationships between users, user permissions, user tablespaces, and user default tablespaces. Select username, default_tablespace from dba_users; 1. view table structure: desc table name 2. view the table of the current user: select table_name from user_tables; 3. view the table names of all users: select table_name from all_tables;
4. view All table names (including system tables) select table_name from all_tables; 5. view All Tables: select * from tab/dba_tables/dba_objects/cat; Under www.2cto.com, the Oracle query user tablespace ◆ Oracle query user tablespace: select * fromuser_all_tables ◆ Oracle queries all functions and stored procedures: select * fromuser_source ◆ Oracle queries all users: select * fromall_users.select * from dba_users
◆ Oracle view current user connection: select * fromv $ Session ◆ Oracle view current user permission: select * fromsession_privs ◆ Oracle view User tablespace usage: select. file_id "FileNo",. tablespace_name "Tablespace_name",. bytes "Bytes",. bytes-sum (nvl (B. bytes, 0) "Used", sum (nvl (B. bytes, 0) "Free", sum (nvl (B. bytes, 0)/. bytes * 100 "% free" from dba_data_files a, dba_free_space B where. file_id = B. file_id (+) group by. tablespace_name,. file_id,. bytes order by. tablespace_name; selectb. file_name physical file name, B. tablespace_name tablespace, B. bytes/1024/1024 size M, (B. bytes-sum (nvl (. bytes, 0)/1024/1024 used M, substr (B. bytes-sum (nvl (. bytes, 0)/(B. bytes) * 100,1, 5) utilization from dba_free_space a, dba_data_files B
Where. file_id = B. file_id and B. tablespace_name = 'hrsm 'group by B. tablespace_name, B. file_name, B. bytesorder by B. tablespace_name1. View All users: select * from dba_user; select * from all_users; select * from user_users; 2. View user system permissions: select * from dba_sys_privs; select * from all_sys_privs; select * from user_sys_privs; 3. View user object permissions: select * from dba_tab_privs; select * from all_tab_privs; select * from user_tab_privs; www.2cto.com 4. view all roles: select * from dba_roles; 5. view the roles owned by the user: select * from dba_role_privs; select * from user_role_privs; 6. view the permissions of the Role: select * from role_sys_privs; select * from role_tab_privs; 7. View All system permissions select * from system_privilege_map; 8. View All object permissions select * from table_privilege_map; www.2cto.com or above is to view User Permissions in Oracle, which is in DB2: select * from syscat. dbauth or get authorizations view sidselect * from v $ instance