Friday, July 8, 2022

Oracle fun without dba privileges

A selection of information you can find on Oracle without special privileges. * Oracle version select * from v$version; * Password expiration date for this user select username,expiry_date from user_users; * Number of rows in this user's tables select table_name,num_rows from all_tables where owner = 'THISUSER' order by table_name; * Possession of the DBMS_LOB role Some critical info DOES require special privileges, including * User session limit * Maximum processes per SID And I'm not sure about * Storage utilization by this user * Storage utilization by this SID * Grants to this user from neighboring users

No comments: