Call: +44 (0)1904 557620 Call

Welcome, Guest. Please Login.
Apr 22nd, 2024, 11:17am
News: If you would like to register contact the forum admin
Home | Help | Search | Members | Login
 1   Oracle General / General Oracle questions / Link to An introduction to simple Oracle auditing  Mar 5th, 2016, 3:21am 
Started by Pete Finnigan | Last post by Pete Finnigan
Hi Pete,
Do you know of any other link where this presentation can be read in its full context?
The only link I can find is the one below and unfortunately the content is getting cut off, the right part of it. ting
Any reply much appreciated. Thanks in advance.
  Reply | Quote | Notify of replies

 2   Oracle Security / Oracle Auditing / Auditing/Reporting DBA Actions  Nov 28th, 2014, 3:53pm 
Started by Pete Finnigan | Last post by Pete Finnigan
Hi, I wonder if anyone can give me some advice here.
Apologies as this is quite long.
This is on Windows platform 2008 R2 64 bit and 10g/11g databases running Enterprise Edition 64bit
I have set up auditing on one of our databases as per compliance requirement.
I am auditing sys operations which are written to the Event Log on the Windows server.
I have a filter log set up filtering on Event ID 34 in Windows
Unfortunately there appears to be a lot of messages regarding backups.  I'm trying to create a process so that it would be easy to spot sysdba logins and actions.
Loads of messages about internal commands relating to what Datapump is doing does not seem helpful to me.
I just ran an rman crosscheck, report obsolete, delete obsolete and a few other clean up commands.
This has caused around 100 records to be written to the event log.
I have set up a test database to audit out to XML to see if this is any better.
Trying to filter out results, everything done by SYSDBA comes in with an ACTION of 0  (UNKNOWN)
Why is this?
Alter database backup controlfile to trace as normal user is recorded as Action 35 (ALTER DATABASE)

Alter database backup controlfile to trace as SYSDBA is recorded as Action 0 (UNKNOWN)

I presume something like Audit Vault would give some nice clear reports about what is going on but there is no appetite to spend any more money on tools at the moment.  
Does anyone know how to make auditing SYSDBA events manageable?
  Reply | Quote | Notify of replies

 3   Oracle Security / Oracle Auditing / Re: Query Rewrite not working with FGA  Jul 23rd, 2014, 9:51am 
Started by Pete Finnigan | Last post by Pete Finnigan
Thanks for your posts Phil,
I was not aware of this bug. I have used FGA with a number of clients on some very big systems and also a small system but not on a data warehouse.
The problem with standard audit and sql capture is that its not row level but at the statement level. Also the performance impact is bigger when SQL is captured and also its global for all audit and cannot be targetted onto just the statements that you need.
Did you test whether you could create a view over the access and then add FGA to the view not the base table? There is a risk that direct access to the base table would bypass the audit but you could create RBAC to prevent this access. Its not ideal but combined with standard audit on the base table perhaps without SQL capture which would then have less performance impact.
A more convoluted approach; maybe you could convert the table to make the important data an object and then the type body could write the audit for you; in this way you can achieve FGA without FGA.
  Reply | Quote | Notify of replies

 4   Security In General / Security / Re: Searching for hash method used  Jul 2nd, 2014, 10:55am 
Started by Pete Finnigan | Last post by Pete Finnigan
Hi Ivan,
Sorry for the late reply; things are very busy for me and I was just told by someone some unanswered posts are on my forum.
There is little to go on except that it could be base64 but it decodes to binary.  
I would look at things like length to see if its a standard length for a known algorithm, or change your password 4 or 5 times and compare the hashes but change your password by one character if you can, so set it to "a" and then "b" or if length is enforced then "passworda" "passwordb"... and see if there is a noticable change in the hash or its completely random. If you can see a pattern its almost certainly not a hash and almost certainly no salt. If its random then it could very well be a hash but if its a salted hash then you would not have the salt (maybe its your username!). If so try an online hash site for common algorithms and try hashing your password to see if you can generate the same value.
  Reply | Quote | Notify of replies

 5   Oracle Security / Oracle Security tools / Re: McAfee products  Jul 2nd, 2014, 10:49am 
Started by Pete Finnigan | Last post by Pete Finnigan
Its a late response, sorry. VP should only be considered really as a stop gap not a permanent solution to not patching. The problem with VP is that the products tend to block remote attacks only and not local attacks and the actual VP technology does not solve other database security issues such as weak passwords, bad privilege design on data  etc.  
A VP product is fine as a belt and braces and I am sure all tghe vendors would agree with me. You cannot replace patching for a long period with these products
  Reply | Quote | Notify of replies

 6   Oracle Security / Oracle Security / Re: How about a Hack Attack platform?  Nov 11th, 2013, 1:08pm 
Started by Pete Finnigan | Last post by Pete Finnigan
Hi Marcel-Jan,
Its a good idea but would need to be done right. The best approach would be to build a virtual box vm with perhaps XE on it and use that as the "host" to the study.
I would be happy to host it here on my site as a free download and also partner in terms of structuring whats in it, lessons, tools, how to secure etc / creating it.  
It could be simply a curriculum I guess with detailed installation instructions on build, setup, exploits etc.
let me know your thoughts
  Reply | Quote | Notify of replies

 7   Oracle Security / Oracle Security tools / oracle-enum-users doesn’t work on Nmap 6.25  May 25th, 2013, 10:57pm 
Started by Pete Finnigan | Last post by Pete Finnigan
I've used the oracle-enum-users script in Nmap in the past, but I couldn't get it working in the latest version. Now I've tried:
- It doesn't work in 6.25.
- It did work in 5.51.
Currently I don't have much time to test the in-between versions.
More at: ork-on-nmap-6-25/
  Reply | Quote | Notify of replies

 8   Oracle Security / Oracle Security / Re: Default passwords  Apr 30th, 2013, 10:47am 
Started by Pete Finnigan | Last post by Pete Finnigan
Before discussing about active / inactive user accounts there is a "Enforcing Password Complexity Verification" rule that defines criterias a password have to fulfill at the time is set. This is not only internally DBA but you will see it everywhere, in OS or other databases. Before discussing about account status the password is breaking the rules. If there is some way attackers can get use of such account (i.e. because locking mechanisms not consistently checked internally but only at logon-time or because bugs/ or way to overpass protections) the accounts will be exposed just because someone ignored this minimal rule at the time of setting that account (password). This is covered by the old NIST CVE-2007-6260 and the advice was to change the default passwords not matter the context or when are set; even the accounts are locked, expired at the end of instance creation; DBCA was changed a bit in 10g but as mentioned in there is a timeframe the instance is vulnerable (could be enough for a trojan like attack) and the same, there is possible that accidentally unlocking to expose on issues. On the other hand, attacks which only require a existing valid account, not matter if active or not (in DoS) could experiment such accounts too. Please note that there is no warning back to DBA about the complexity of the password when a DBA is unlocking user accounts and theoretically there are no clues about the fact that for i.e. user apps_002 is having password identical with user name (because of privacyHuh) so a DBA is simple unlocking the user not being aware about the fact it is opening the DB for intruders. Regards, Paul B.
  Reply | Quote | Notify of replies

 9   Security In General / Security / Re: Introduction into Cryptography course  Nov 10th, 2012, 10:43pm 
Started by Pete Finnigan | Last post by Pete Finnigan
Forgot to tell: I did it. I managed to score 70% percent of the problem sets (average) and the exam of Cryptography I and got a statement of accomplishment.  
It was a time intensive course, but it already is paying off. In insight that is. When I have to configure certificates for a site, I actually know what's under the cover.
I'm going to do Cryptography II as well (in january). It will cover certificates more thoroughly, amongst others.  
Oh by the way, you can do Cryptography I every couple of months. A new course started november 5th.
  Reply | Quote | Notify of replies

 10   Oracle Security / Oracle Security / Re: TNS Poisoning  Sep 4th, 2012, 8:27am 
Started by Pete Finnigan | Last post by Pete Finnigan
Hi Laurent,
Thanks for the update, i hope it is useful for those who have not worked to solve this issue yet.
  Reply | Quote | Notify of replies

Return to the board index.

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright © 2000-2004 Yet another Bulletin Board
  • PFCLScan PFCLScan

    Simply connect PFCLScan to your Oracle database and it will automatically discover the security issues that could make your Oracle database vulnerable to attack and to the potential loss of your data.

  • PFCL Obfuscate PFCLObfuscate

    PFCLObfuscate is the only tool available that can automatically add license controls to your PL/SQL code. PFCLObfuscate protects your Intellectual Property invested in your PL/SQL database code.

  • PFCLCode PFCLCode

    PFCLCode is a tool to allow you to analyse your PL/SQL code for many different types of security issues. PFCLCode gives you a detailed review and reports and includes a powerful colour syntax highlighting code editor

  • PFCLForensics PFCLForensics

    PFCLForensics is the only tool available to allow you to do a detailed live response of a breached Oracle database and to then go on and do a detailed forensic analysis of the data gathered.

  • Products We resell PFCLReselling Limited has partnered with a small number of relevant companies to resell their products where they enhance or compliment what we do


    PFCLATK is a toolkit that allows detailed pre-defined policy driven audit trails for your Oracle database. The toolkit also provides for a centralised audit trail and centralised activity reporting

  • PFCLCookie PFCLCookie

    PFCLCookie is a useful tool to use to audit your websites for tracking cookies. Scan websites in a natural way using powerful browser driven scanner

  • PFCL Training PFCLTraining

    PFCLTraining is a set of expert training classes for you, aimed at teaching how to audit your own Oracle database, design audit trails, secure code in PL/SQL and secure and lock down your Oracle database.

  • PFCL Services PFCLServices

    Choose PFCLServices to add Ltd to your team for your Oracle Security needs. We are experts in performing detailed security audits, data security design work and policy creation

  • PFCLConsulting PFCLConsulting

    Choose PFCLConsulting to ask Limited to set up and use our products on your behalf

  • PFCLCustom PFCLCustom

    All of our software products can be customised at a number of levels. Choose this to see how our products can be part of your products and services

  • PFCLCloud PFCLCloud

    Private cloud, public cloud, hybrid cloud or no cloud. Learn how all of our services, trainings and products will work in the cloud

  • PFCLUserRights PFCLUserRights

    PFCLUserRights allows you to create a very detailed view of database users rights. The focus of the reports is to allow you to decide what privileges and accounts to keep and which to remove.


    PFCLSTK is a toolkit application that allows you to provide database security easily to an existing database. PFCLSTK is a policy driven toolkit of PL/SQL that creates your security


    PFCLSFTK is a toolkit that solves the problem of securing third party applications written in PL/SQL. It does this by creating a thin layer between the application and database and this traps SQL Injection attempts. This is a static firewall.


    PFCLSEO is a web scanner based on the PFCLScan technology so that a user can easily scan a website for technical SEO issues