Script to pull/show a database user’s privileges or clone a user by query.
Oct 27 2021
Oct 16 2020
Sometimes DBA needs to generate the report to provide audit team or management about the users access information on database. In this article, I will show how to get list of access for oracle user. Query to find all privileges for all users in Database:
Jun 15 2020
Applying patch is one the main maintenance task for a DBA. DBA team needs to give lots of effort to apply patch in every quarter. To minimize the manual effort I tried to make patching automation which will support following environments: It will support for 11g and 12c Databases Including RAC and Standalone It will …
Jan 16 2020
Sometimes DBA need to verify or compare multiple tables record count. It is really time consuming to compare one by one table count. So, by using this query, you will able to get record count report for multiple tables in Oracle.
Nov 13 2019
Monitoring: Load by Users Generate Kill Sessions from query List Privilege Load by Users Process Details Schema Size Tables Record Count