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
    What does the future hold for Data Analytics? AI & ML, of course. https://t.co/H0Y2JpORwx

    4 weeks ago
  • mfdba
    @mfdba
    Like fruits and veggies in a supermarket a Data Mesh treats data as a consumable product. https://t.co/6ZWWW5GasU

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

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

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

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

    2 years ago

Tags

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

Admin

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