HOW TO FIND ALL OBJECTS PRIVILEGES GRANTED TO A USER IN AN ORACLE DATABASE
Here is a query to a data dictionary table for finding out all the object privileges that…
HOW TO FIND SYSTEM, ROLES AND OBJECTS PRIVILEGES THAT HAVE BEEN GRANTED TO A USER
How to find the privileges that have been granted to a user by querying data dictionary views.
HOW TO RETRIEVE AN OBJECT DDL OR A USER DDL USING PL/SQL
How to extract metadata of users, tables, views, triggers, and other Oracle database objects by using the…
HOW TO BACKUP AN INITIALIZATION PARAMETER FILE BY QUERYING A DATABASE VIEW
A query to list all of the parameter values currently used by an instance.
HOW TO QUERY THE HIDDEN PARAMETERS IN AN ORACLE DATABASE
A query to view all the hidden parameter and their default values.
SQLPLUS : DYNAMIC NAME FOR A SPOOL FILE
The post provides a way to change the spool file name dynamically during a SQL script execution.
WHAT ORACLE_HOME WAS USED TO START UP A DATABASE INSTANCE?
A query to get the ORACLE_HOME path in an Oracle Database.
HOW TO GET ORACLE NLS SETTINGS DEFINED ON DATABASE, INSTANCE, AND SESSION LEVELS
A database query to fetch Oracle NLS settings defined on a database, an instance, and session levels.