-- View the relationship between the user and the default table space

select username,default_tablespace from dba_users;

-- View the tables that the current user can access

select * from user_tables; 

--Oracle Query user table

select * from user_all_tables;

--Oracle Query user view

select * from user_views;

-- Query all functions and stored procedures :

select * from user_source;

-- Query all users :
select * from all_users;

select * from dba_users

-- View current user connections :

select * from v$Session;

-- View user roles

SELECT * FROM USER_ROLE_PRIVS;

-- View current user permissions :

select * from session_privs;

-- View roles owned by all users

SELECT * FROM DBA_ROLE_PRIVS;

-- View all roles

select * from dba_roles;

-- View database name

SELECT NAME FROM V$DATABASE;

-- View all table space usage
select a.file_id "FileNo",
       a.tablespace_name "Tablespace_name",
       a.bytes "Bytes",
       a.bytes - sum(nvl(b.bytes, 0)) "Used",
       sum(nvl(b.bytes, 0)) "Free",
       sum(nvl(b.bytes, 0)) / a.bytes * 100 "%free"
  from dba_data_files a, dba_free_space b
 where a.file_id = b.file_id(+)
 group by a.tablespace_name, a.file_id, a.bytes
 order by a.tablespace_name;

Technology
©2019-2020 Toolsou All rights reserved,
What are the protection measures for website security ? Talking about uni-app Page value transfer problem Remember once EventBus Project issues caused by memory leaks I've been drinking soft water for three years ? What is the use of soft water and water softener Time conversion front desk will 2020-07-17T03:07:02.000+0000 Into 2020-07-17 11:07:02 Chuan Shen Count the number of letters (java Language implementation ) Time format 2020-01-13T16:00:00.000Z Medium T and Z What do they mean , How to deal with it msf Generate Trojan horse attack android mobile phone The world's first free open source ERP Odoo Ubuntu The best development environment What's the difference in server prices ?