Skip to content
  • Twitter
  • LinkedIn
  • GitHub
  • Instagram

Mark Fennell

Azure Architect / DBA / Web Developer

  • Resume
  • About Me
  • Creative
  • Contact

Month: October 2013

Selective Oracle Logon Trigger for Auditing

7 October 20137 October 2013 mark fennellOracle

The Oracle logon trigger can be a very powerful tool for recording who or what is accessing your database. However, you may not need to know when every user or every host or even a specific application logs into Oracle. The following trigger shows one possibility for selectively auditing user logons.

ORA-28221: REPLACE not specified

7 October 20137 October 2013 mark fennellOracle

I came across a problem today in which a user could not reset her password without getting the “ORA-28221: REPLACE not specified” error. The correct “alter user” syntax to resolve this error is: alter user USERNAME identified by NewPassword replace OldPassword;

Mark Fennell

exceptional IT professional; motivated, insightful, customer-focused; curious listener; database administrator; web application developer; models complex business processes;

Latest Tweets

  • mfdba
    @mfdba
    Come work with the world's best. https://t.co/o3cnJPDdHm https://t.co/hPWvUadBiD

    6 months ago
  • mfdba
    @mfdba
    Insight is #hiring #dataarchitects with experience in #sqlserver, #databricks, #snowflake, #powerbi and more. https://t.co/VuvESMfQPm

    6 months ago
  • mfdba
    @mfdba
    Know anyone who might be interested in working with #azure, #awsamazon, #databricks and #snowflake to build cutting… https://t.co/FxviOkppkg

    9 months ago
  • mfdba
    @mfdba
    My company @InsightEnt is hiring Data and AI Architect professionals. If you're ready to grow your career and help… https://t.co/UmV1VscTzp

    12 months ago
  • mfdba
    @mfdba
    Insight is #hiring engineers with #powerbi skills or #databricks skills or both. https://t.co/nVPhGO7wLj

    1 year ago
  • mfdba
    @mfdba
    What do you get when your snowflake model melts? A data lake.

    2 years ago

Tags

JavaScript ColdFusion Oracle Programming NoSQL Linux Azure PowerShell Personal Other General SQL Server Aquariums CSS

Admin

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress | Theme: Amadeus by FlyFreeMedia.