Category: Scripting

Oct 27 2021

Clone a Database User by Query

By dbasamad in Scripting

Script to pull/show a database user’s privileges or clone a user by query.

Oct 16 2020

How to Show All Privileges for a User in Oracle Database

By dbasamad in Scripting

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

Patch (PSU) Automation

By dbasamad in Scripting

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

Multiple Tables Record Count by a Single Query

By dbasamad in Scripting

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.