• About
  • All Posts
  • 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

Tag: security

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

April 15, 2019 Uncategorized

Quick and easy masking

I had a request from a client a while back regarding masking of data. They had an application with sensitive

Continue reading

March 7, 2019 Uncategorized

Connections with a wallet – redux

Wow…it is nearly 4 years ago now that I wrote an article on connecting to the database via a wallet

Continue reading

January 11, 2019 Uncategorized

My APEX was fine and then it wasn’t

I got a nasty shock this morning when I fired up my local Application Expression installation. It had been working

Continue reading

December 31, 2018 Uncategorized

Your New Years Resolution

Aligning roughly with the calendar year, based on the Chinese zodiak we’re about to go from the year of the

Continue reading

October 31, 2018 Uncategorized

The strange place for INHERIT PRIVILEGES

A while back in an Office Hours session, I touched on a relatively new privilege in the database called INHERIT

Continue reading

August 18, 2017 Uncategorized

Choosing a password scheme for the database

In the Security Guide there is a section to assist you with the decisions about what rules you might want

Continue reading

July 24, 2017 Uncategorized

Quick tip–database link passwords

If you are relying on database links in your application, think carefully about how you want to manage the accounts

Continue reading

Posts navigation

1 2 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

  • PL/SQL in 21c gets amazing new loop iterators
  • How to do a GRANT on an entire schema
  • Why you keep getting "ORA-01653: unable to extend table"
  • No more stale statistics in 19c
  • APEX 20.2 comes to town (well, to my PC)
  • Cross-platform database migration
  • The death of UTL_FILE
  • Connection shortcuts with a wallet
  • Complex materialized views and fast refresh
  • My APEX was fine and then it wasn't
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel