• 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

November 2, 2022 Uncategorized

A Security Disaster

There has been a lot of coverage here in Australia recently about one of our popular telco’s getting hacked due

Continue reading

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

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.

Tweets by connor_mc_d

    Top Posts & Pages

    • How to do a GRANT on an entire schema
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to TREAT data in a CLOB as JSON
    • Connection shortcuts with a wallet
    • How to generate random unique values
    • Generating INSERT scripts that run fast!
    • No more stale statistics in 19c
    • Free In-memory in Oracle Database 19c
    • Updating indexes with partition maintenance
    • Automatically generate audit capture for tables
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 852 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...