Call: +44 (0)1904 557620 Call

Pete Finnigan's Oracle Security Weblog

This is the weblog for Pete Finnigan. Pete works in the area of Oracle security and he specialises in auditing Oracle databases for security issues. This weblog is aimed squarely at those interested in the security of their Oracle databases.

[Previous entry: "Another great recovery disk - This time a CD"] [Next entry: "Three great papers on shell codes and encoding and decoding"]

Ed's latest post in the catpatch.sql series - missing SELECT ANY DICTIONARY PRIVILEGE

I just came across Edwards post made yesterday in his issues of not running catpatch.sql series. This post is entitled Missing SELECT ANY DICTIONARY privilege granted to the DBA role. This post talks about how SELECT ANY DICTIONARY replaced SELECT ANY TABLE in 9i as the privilege to get access to the dollar tables. Edwards post goes on to talk about migrations from 8iR3 to 9i where the SELECT ANY DICTIONARY privilege goes missing if a migration fails.