http://www.petefinnigan.com/weblog/entries PeteFinnigan.com's weblog is the only weblog dedicated to Oracle security. en-gb Copyright PeteFinnigan.com Ltd 2005, All rights reserved. All trademarks are the property of their respective owners and are hereby acknowledged 2019-12-28T14:26:11Z Pete Finnigan (mailto:webmaster\@petefinnigan.com) Pete Finnigan (mailto:pete\@petefinnigan.com) PeteFinnigan.com's weblog is the only weblog dedicated to Oracle security. Pete Finnigan's Oracle security weblog http://www.petefinnigan.com/images/company_logo_1.gif http://www.petefinnigan.com/weblog/entries http://www.petefinnigan.com/weblog/archives/00001463.htm I needed to create a new 19c install yesterday for a test of some customer software and whilst I love Oracle products I have to say that installing the software and database has never been issue free and simple over....<a href="http://www.petefinnigan.com/weblog/archives/00001463.htm">[Read More]</a> <p>Posted by Pete On 06/12/19 At 04:27 PM</p> http://www.petefinnigan.com/weblog/archives/00001462.htm We have one set of Manuals for the recent training we held here in York and one from 2018. These can be bought as individual books as follows: This manual is from the York class in October 2019 and can....<a href="http://www.petefinnigan.com/weblog/archives/00001462.htm">[Read More]</a> <p>Posted by Pete On 19/11/19 At 03:05 PM</p> http://www.petefinnigan.com/weblog/archives/00001461.htm There has been a few blog posts over the years discussing what is the difference between SELECT ANY DICTIONARY and the SELECT_CATALOG_ROLE. Hemant posted in 2014 about the difference between SELECT ANY DICTIONARY and SELECT_CATALOG_ROLE . This post was a....<a href="http://www.petefinnigan.com/weblog/archives/00001461.htm">[Read More]</a> <p>Posted by Pete On 11/10/19 At 01:59 PM</p> http://www.petefinnigan.com/weblog/archives/00001460.htm Oracle has a lot of privileges and models; privileges can be granted to users, roles and also since 12c roles can be granted to PL/SQL code (I will not discuss this aspect here as i will bog separately about grants....<a href="http://www.petefinnigan.com/weblog/archives/00001460.htm">[Read More]</a> <p>Posted by Pete On 08/10/19 At 01:43 PM</p> http://www.petefinnigan.com/weblog/archives/00001459.htm I posted yesterday a blog about an error on a sequence of ORA-01950 on tablespace USERS - ORA-01950 Error on a Sequence . This was attributed to the sequence by me because that's where the error in Oracle was pointing....<a href="http://www.petefinnigan.com/weblog/archives/00001459.htm">[Read More]</a> <p>Posted by Pete On 01/10/19 At 01:12 PM</p> http://www.petefinnigan.com/weblog/archives/00001458.htm UPDATE: I have updated information for this post and rather than make this one much longer i created a new post - please see ORA-01950 Error on a Sequence - Error on Primary Key Index Wow, its been a while....<a href="http://www.petefinnigan.com/weblog/archives/00001458.htm">[Read More]</a> <p>Posted by Pete On 30/09/19 At 01:42 PM</p> http://www.petefinnigan.com/weblog/archives/00001457.htm We are very excited to announce that we are currently working to have version 3.0 of PFCLScan our flagship database security scanner for the Oracle database. We will be ready for sale in September and this development is going really....<a href="http://www.petefinnigan.com/weblog/archives/00001457.htm">[Read More]</a> <p>Posted by Pete On 11/07/19 At 03:33 PM</p> http://www.petefinnigan.com/weblog/archives/00001456.htm We have a toolkit called PFCLATK that is used in customer engagements to assist our customers to create comprehensive and useful audit trails for their databases. The toolkit is used in consulting engagements at the moment but will be adding....<a href="http://www.petefinnigan.com/weblog/archives/00001456.htm">[Read More]</a> <p>Posted by Pete On 06/06/19 At 03:08 PM</p>