• About
  • All Posts
  • The Podcast!
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists
  • The Podcast!

Tag: security

a large bank safe locked shut
May 25, 2022 Uncategorized

Is my table marked for archive?

In 12c, we introduced a feature call Row Archival, which is a means of integrating typical archival models that we

Continue reading

February 6, 2022 Uncategorized

A new dictionary view for privileges

So I tweeted this out on Friday and this reflects one of my joys with working with Oracle technology. The

Continue reading

January 13, 2022 Uncategorized

UTL_HTTP, secure hosts and ORA-24263 certificate errors

Security eh? It is just one of those little things that is good to have in a database. The “problem”

Continue reading

the logo for log4j
December 22, 2021 Uncategorized

Twas the night before … log4j

‘Twas the week before Christmas, and all through the world, Many developers were stirring, as a nightmare unfurled. The log4j

Continue reading

August 30, 2021 Uncategorized

21c … a more secure DataPump

With the new release of every product from every software vendor, there are always the big banner headline features that

Continue reading

February 3, 2021 Uncategorized

Blockchain tables are here in 19c!

Slow down there….Take a breath. Because if you’ve read the title of this post and you’re already logging on to

Continue reading

February 1, 2021 Uncategorized

Blockchain tables in 21c? A word of warning

As I write this, the moment you do a browser search for “blockchain”, the last thing you will get a

Continue reading

barbed wire security
August 25, 2020 Uncategorized

How to do a GRANT on an entire schema

TL;DR: There is no schema grant command in Oracle, but this routine lets you get close. Why no schema level

Continue reading

August 12, 2020 Uncategorized

How to stop your site from being Clickjacked!

In the language of the millennials I should start this post with “TIL”, but for the rest of us out

Continue reading

March 24, 2020 Uncategorized

Tightened security in 20c for Oracle maintained accounts

If you cannot wait for a fully autonomous offering, and you’ve jumped into the 20c preview release on Oracle Cloud,

Continue reading

Posts navigation

1 2 3 Next Posts»

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Top Posts & Pages

  • How to do a GRANT on an entire schema
  • Why you keep getting "ORA-01653: unable to extend table"
  • Extending in-lists past the 1000 item barrier
  • Connection shortcuts with a wallet
  • No more stale statistics in 19c
  • How to TREAT data in a CLOB as JSON
  • Automatically generate audit capture for tables
  • Generating INSERT scripts that run fast!
  • Comparing two database objects for differences
  • How to generate random unique values
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 814 other followers
    • Already have a WordPress.com account? Log in now.
    • Learning is not a spectator sport
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...