This article details how to make a “god user” in the database. Creating a god user isn’t something you want to do with your production databases. Generally, you want to follow the principle of least privilege. In other words, only… Read More
View Hidden Parameters in Oracle
Occasionally I need to view hidden parameters in Oracle. There are plenty of queries and scripts that already do this out there. But these queries have to be run as SYS. So when I need to view hidden parameters, I… Read More
Summing Interval Data Types
Something I’ve occasionally thought would be really nice is if Oracle had a good way of summing interval data types, much the same way that you can SUM() number data types. Occasionally I’ve designed processes that record start and stop… Read More
How to Set a Sequence Value in Oracle
If you are running a version of Oracle that is prior to 12.1, there’s no “easy” way to set a sequence value. This changes in Oracle 12.1 though; you can simply issue the ALTER SEQUENCE .. RESTART command to set… Read More
Use DBMS_METADATA to get DDL for Row Level Security (RLS) Policy
I needed to drop a Row Level Security Policy from a table in an Oracle 12.1 database; but before I removed the policy, I wanted to make a backup of the code that would be necessary to restore the policy… Read More