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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment