-- 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,
Non preemptive static priority scheduling algorithm for operating system (C language )Go Language learning notes (GUI programming )XCTF Attack and defense world web Advanced practice _ 2_lottery What's the difference between computer major and training background ?python realization vlookup_ Dry goods I : Why python It's inside vlookup Bubble sort primary springboot2 Separation of front and rear platforms ,token Put in header Pit for verification Python Case conversion of letters ( Two methods )javascript event ( Detailed explanation of zero basis )Unity2019 UIElement note ( ten ) Simple exercise 2