10 September 2010

Preventative

Posts relating to the category tag "preventative" are listed below.

02 July 2010

Web Site Security Basics for SMEs

Sometimes when I'm out socially and people ask what I do, the conversation progresses to concerns about their own web site. They may have a hobby site, run a micro-business or be a manager or director of a small and medium-sized enterprise (SME)—there's all sorts of great entrepreneurial activity going on.

It is very common for SMEs not to have much time or budget for information security, and the available information can be poor or inappropriate (ISSA-UK, under the guidance of their Director of Research David Lacey, is trying to improve this). But what can SMEs do about their web presence—and it is very unusual not to have a web site, whatever the size of business.

Photograph of a waste skip at the side of St John Street in Clerkenwell, London, UK, with the company's website address written boldly across it

Last week I was asked "Is using <company> okay for taking online payments?" and then "what else should I be doing?". Remember we are discussing protection of the SME's own web site, not protecting its employees from using other sites. If I had no information about the business or any existing web security issues, this is what I recommend checking and doing before anything else:

  • Obtain regular backup copies of all data that changes (e.g. databases, logs, uploaded files) and store these securely somewhere other than the host servers. This may typically be daily, but the frequency should be selected based on how often data changes and how much data the SME might be prepared to lose in the event of total server failure.
    • check backup data can read and restored periodically
    • don't forget to securely delete data from old backups when they are no longer required
  • Use a network firewall in front of the web site to limit public (unauthenticated user) access to those ports necessary to access the web site. If other services are required remotely, use the firewall to limit from where (e.g. IP addresses) these can be used.
    • keep a record of the firewall configuration up-to-date
    • limit who can make changes to the firewall
  • Ensure the host servers are fully patched (e.g. operating system, services, applications and supporting code), check all providers for software updates regularly and allow time for installing these.
    • remove or disable all unnecessary services and other software
    • delete old, unused and backup files from the host servers
  • Identify all accounts (log in credentials) that provide server access (not just normal web page access), such as used for transferring files, accessing administrative interfaces (e.g. CMS admin, database and server management/configuration control panels) and using remote desktop. Change the passwords. Keep a record of who has access and remove accounts that are no longer required and enable logging for all access using these accounts.
    • restrict what each account can do as much as possible
    • add restrictions to the use of these accounts (e.g. limit access by IP address, require written approval for use, keep account disabled by default)
  • Check that every agreement with third parties that are required to operate the web site are in the organisation's own name. These may include the registration of domain names, SSL certificates, hosting contracts, monitoring services, data feeds, affiliate marketing agreements and service providers such as for address look-up, credit checks and making online payments.
    • ensure the third parties have the organisation's official contact details, and not those of an employee or of the site's developers
    • make note of any renewal dates
  • Obtain a copy of everything required for the web site including scripts, static files, configuration settings, source code, account details and encryption keys. Keep this updated with changes as they are made.
    • verify who legally owns the source code, designs, database, photographs, etc.
    • check what other licences affect the web site (e.g. use of open source and proprietary software libraries, database use limitations).

Do what you can, when you can. Once those are done, then:

  • Verify the web site and all its components (e.g. web widgets and other third party code/content) does not include common web application vulnerabilities that can be exploited by attackers (e.g. SQL injection, cross-site scripting).
  • Check what obligations the organisation is under to protect business and other people's data such as the Data Protection Act, guidance from regulators, trade organisation rules, agreements with customers and other contracts (e.g. PCI DSS via the acquiring bank).
    • impose security standards and obligations on suppliers and partner organisations
    • keep an eye open for changes to business processes that affect data
  • Document (even just some short notes) the steps to rebuild the web site somewhere else, and to transfer all the data and business processes to the new site.
    • include configuration details and information about third-party services required
    • think about what else will need to be done if the web site is unavailable (does it matter, if so what exactly is important?)
  • Provide information to the web site's users how to help protect themselves and their data.
    • point them to relevant help such as from GetSafeOnline, CardWatch and Think U Know
    • provide easy methods for them to contact the organisation if they think there is a security or privacy problem
  • Monitor web site usage behaviour (e.g. click-through rate, session duration, shopping cart abandonment rate, conversion rate), performance (e.g. uptime, response times) and reputation (e.g. malware, phishing, suspicious applications, malicious links) to gather trend data and identify unusual activity.
    • web server logs are a start, but customised logging is better
    • use reputable online tools (some of which are free) to help.

That's just the basics. So, what would be next for an SME? If the web site is a significant sales/engagement channel, the organisation has multiple web sites, is in a more regulated sector or one that is targetted particularly by criminals (e.g. gaming, betting and financial), takes payments or does other electronic commerce, allows users to add their own content or processes data for someone else, the above is just the start. Those SMEs probably need to be more proactive.

This helps to protect the SME's business information, but also helps to protect the web site users and their information. After all, the users are existing and potential customers, clients and citizens.

Oh, the best response I had to someone when I was explaining my work: "You're an anti-hacker than?". Well, I suppose so, but it's not quite how I'd describe it.

Any comments or suggestions?

Posted on: 02 July 2010 at 08:18 hrs

Comments Comments (0) | Permalink | Send Send | Post to Twitter

25 June 2010

Financial Promotions Using New Media

My previous mention of the Financial Services Authority (FSA) had suggested they would survive the new government in the UK. This is no longer the case as the FSA is to be broken up by 2012.

Partial view of the cover from the FSA's new document 'Financial Promotions Industry Update, No. 5 - June 2010, Financial promotions using new media'

But regulation continues for the moment and, following a review undertaken in February, the FSA has published a new update on Financial Promotions Using New Media. New media communication channels include "social networking websites (Twitter and Facebook), forums, blogs and i-phone applications". So presumably any web site or mobile phone application where a regulated firm communicates.

The guidance explains the rules relating to the content of communications (e.g. stand-alone compliance and communication rules contained in COBS 4, BCOBS 2, ICOBS 2 and MCOB 3) are no different than for other media, and includes non-promotional communication such as directly with existing clients.

So what extra guidance for new media is there? The document highlights:

  • regular reviews are required to ensure information is up-to-date
  • some channels may be inappropriate for the particular communication to ensure it is balanced and provides sufficient information (e.g. Twitter where the length of each message is very restricted)
  • consideration as to how risk information can be highlighted varies across the channels.

The FSA notes that most new media communications does not benefit from the exemptions for image advertising.

Posted on: 25 June 2010 at 09:38 hrs

Comments Comments (0) | Permalink | Send Send | Post to Twitter

24 June 2010

OWASP AppSec Research 2010 - Part 2

Last night, after the first day of the OWASP AppSec Research 2010 conference, we had the pleasure of attending the conference gala dinner at the lavishly decorated Stockholm City Hall, also used for the annual Nobel Prize award ceremony.

Photograph of Steve Lipner giving his keynote speech at AppSec EU Research 2010 in Stockholm, Sweden

Steve Lipner (Microsoft) gave the keynote speech today. He described the early step, creation and evolution of Microsoft's Security Development Lifecycle (SDL). This began in early 2002 which included team-wide security training, the introduction of early threat modelling, code review, use of some tools, undertaking security testing and modifying software defaults to make them more secure. These were seen as quick wins but were immature and ad-hoc processes. They then worked on the security "science" and "security audit" to build a more robust and repeatable program leading to the first edition of the SDL in 2004. It is regularly reviewed and updated and version 5.0 was released this year and 5.1 is due in October 2010. Whilst the SDL is based on Microsoft's own experiences and culture, he said it can be applied to non-Windows development, it does not rely on Windows tools and is not just for shrink-wrapped software development. Neither is it only suitable for waterfall or spiral development methodologies; the application of SDL to agile processes has been described recently. But the most important point he made is that SDL at Microsoft is not necessarily what will work in other software development teams—it is a very helpful starting point, but requires commitment and time to create processes and apply these consistently.

Immediately following the keynote speech, Pravir Chandra (Fortify and OWASP SAMM Project Leader) outlined the Software Assurance Maturity Model (SAMM) and lessons learned in its application to real software development programs. He emphasised the need to identify and classify all applications by risk, to determine what security activities are undertaken. He described that the argument for secure software development must be a business argument based on risk, that it has a real return on investment (ROI), and starting with a single development process and enhancing that can be a good way to introduce secure development practices. The activities undertaken need to be mapped to preventative, detective and corrective controls, and that the tasks need to specify roles, responsibilities and mappings to process flows. Also, he said that security knowledge needs to be spread widely with champions and experts, not just kept by a single specialist or group. He believes SAMM has a large proportion of overlap with Microsoft SDL and BSIMM, and is in the process of mapping SAMM's activities to the latter.

Photograph of David Rajchenbach-Teller presenting at AppSec EU Research 2010 in Stockholm, Sweden

David Rajchenbach-Teller (MLState) described a new programming language for web applications called OPA. It has been designed from a clean start to avoid legacy concepts from the 1970s and 80s and is based on formal methods, is safe from the bottom up, using a single language for the whole application and is based on the distributed system model where not all principals are trusted, communications use web standards and security is mostly automatic. He showed some example code and described real applications in use today. He then described how it prevents a number of issues in the OWASP Top Ten 2010 but that is still under development, and for example, they are working on cross-site request forgery (CSRF) prevention mechanisms and extending the security policy feature set.

Photograph of Cassio Goldschmidt presenting at AppSec EU Research 2010 in Stockholm, Sweden

Cassio Goldschmidt (Symantec and SAFECode) presented an engaging explanation of how we are all responsible to a certain extent for the creation of software flaws. Whilst software manufacturers may be increasingly applying secure development practices, software is very complex, there are multiple layers of software on top of software and there is no effective way to prove software correctness. Adopters (e.g. home and corporate users) desire feature-rich software and security is not always visible. The environment affects purchasing decisions and home users in particular may not keep software patched. He said purchasing decisions in corporate entities may be made by different people than the users leading to a disconnect, and even patching can be delayed due to corporate cycles. Security researchers also have a part to play where the motivation and consequences of actions are not always transparent. Similarly governments find it difficult to make good law and the timescales cannot keep up with the fast pace of developments. They may provide incentives or require higher standards, but these can be blunt instruments. In summary he proposed that economics plays a larger part than technical solutions to the risks and impacts, even thought industry is moving in the right direction.

Photograph of lunchtime in Aula Magna, the great auditorium of Stockholm University, at AppSec EU Research 2010 in Stockholm, Sweden

During and after lunch, OWASP board members and leaders discussed opportunities, issues and proposals to assist end-users find organisations who are providing products and services based on OWASP's knowledgebase.

Photograph of sponsor's information booths at AppSec EU Research 2010 in Stockholm, Sweden

Nick Nikiforakis (KU Leuven) described their analysis of eight file sharing services that are cloud-based, provide "one-click hosting" and are mostly anonymous. They found that although the services tended to offer both private distribution (e.g. by email link or instant messaging) and public distribution (e.g. links added to forums, blogs, etc) most of the services were relying on obscurity through obscurity. In many cases the URL token was predicable and even if the source filename was included, this was often not required. Given the predictability of tokens, they were able to obtain details of many different files on the file sharing systems, and tried to identify which were of the private or public type by an examination of whether the source filename could be found elsewhere using Yahoo. The remaining non-binary types were downloaded and examined to find a wide variety of data including bank statements, company budgets & salaries, personal data, documents with admin credentials, doctors notes and even a death certificate. Their advice, choose file sharing systems that have unpredictable tokens, encrypt the files and remove from the store as soon as possible.

Photograph of the closing ceremony at AppSec EU Research 2010 in Stockholm, Sweden, with John Wilander thanking the OWASP Board for their support

The conference closed with thanks being given to the organisers, Kate Hartmann (OWASP Operations Director), OWASP board, helpers from the university, the sponsors, the sound and video teams, the caterers and the attendees. Prizes from various sponsor competitions and the capture the flag event were given. John Wilander reminded attendees about the upcoming AppSec US 2010 in September and announced that next year's AppSec EU would be help in Trinity College, Dublin, Ireland, and in Athens the year after.

Congratulations to the team from Sweden, Norway and Denmark for such a well-organised, and excellent appsec conference!

Posted on: 24 June 2010 at 23:59 hrs

Comments Comments (0) | Permalink | Send Send | Post to Twitter

23 June 2010

OWASP AppSec Research 2010 - Part 1

The Open Web Application Security Project (OWASP) AppSec Research 2010 conference started this morning following the previous two days of application security training. The conference began with a welcome and introduction from the primary organiser and OWASP Sweden chapter leader, John Wilander, and the OWASP Board.

Photograph of Tom Brennan, OWASP Foundation Board member, at the opening of OWASP AppSec Research 2010 in Sweden, Stockholm

This was immediately followed by the keynote address on Cross-Domain Theft and the Future of Browser Security by Chris Evans and Ian Fette (Google). They described how attacks are increasingly targetting the browser, and nowadays this may may mean its plug-ins rather than the browser itself. Browsers are generally moving to being sandboxed but it is harder to sandbox the plug-ins and it is operating system, as well as browser, specific. Chris described future softspots and the possible growth of multi-payload malware that tries to exploit two vulnerabilities e.g. to exploit code and then escape a sandbox. Ian described the large proportion of search engine results that seem to be phishing or malware sites and how blacklisting can help defend users. Interestingly he mentioned Google actually visits suspicious websites in a virtual machine to check whether malware exists.

The remainder of the day was split into three parallel tracks.

After the keynote, I attended the presentation by Lieven Desmet (KU Leuven) on client-side cross-site request forgery defence measures and their own CsFire Firefox extension. It builds upon previous efforts, particularly RequestRodeo (Martin Johns, 2006) but aims to provide a much more usable experience with very little user involvement. The extension is available to download and the team are looking for feedback, especially with problems caused with particular websites. They believe a combination of server and local policies may overcome these issues, such as sites spanning multiple domains.

Delegates seated in the lecture theatre at OWASP AppSec Research 2010 in Sweden, Stockholm

Ivan Ristic presented the main threats against SSL (implementation flaws, rogue certification authority certificates, rogue certification authorities, usability issues, and application & configuration vulnerabilities. He then went on to describe the principal SSL deployment mistakes—these are very important considerations to take into account, especially in the design of a new website. His recommendation: create the site completely SSL-only from the start. And, use the free information and tools at SSL Labs.

The problem of using static code analysis tools with source code built using open source, proprietary and home-grown frameworks was described by Christain Hang (Armorize Technologies). He described how reflection, invocation sequence and cross-content propagation can lead to false positive and false negative results. For example, in the Struts framework for Java he showed how detailed knowledge of the configuration XML file is needed. He suggested that asking users to hard-code the analysis tool's configuration, or for the tool's developers to build support for each framework are unsustainable. His recommendation was to dynamically translate the framework logic into the source code, so the two are stitched together before the analysis is undertaken. He says it is not perfect, but it is easily extendible and equally applicable to home-grown frameworks.

Vendor stands at OWASP AppSec Research 2010 in Sweden, Stockholm

After lunch, Mike Samuel and Jasvir Nagra (Google) described the Caja project and how it can help (in particular larger, more mature social networking sites), where the same origin policy is not sufficient, and policies need to change quickly to meet new demands and threats. The technique uses the concept of virtualisation to isolate and control the flow of third party HTML, JavaScript and CSS to the end user.

Mike Samuel and Jasvir Nagra from Google at OWASP AppSec Research 2010 in Sweden, Stockholm

Johan Lindfors and Dag Konig (Microsoft) outlined the variety of security tools available for .NET development and testing. These included demonstrations of Team Foundation Server, Threat Modelling Tool, and an overview of FxCop, CAT.NET, Pex, Moles and the Web Application Configuration Editor. They also described the concepts behind code contracts. There is more about these on the security tools blog.

David Byrne and Charles Henderson (Trustwave), outlined the pros and cons of manual and automated testing. They moved onto examples that only manual testing would fine, and reminded the audience to to remember that vulnerabilities also come from (product/organisation) acquisitions, old/dead code and in third party libraries.

Panel discussion at OWASP AppSec Research 2010 in Sweden, Stockholm

The day closed with a panel discussion about whether application security is fighting a losing battle.

The research papers, presentations, demonstrations from all three tracks are listed on the conference website, where the presentations, and recorded videos, will be available in due course.

Posted on: 23 June 2010 at 17:24 hrs

Comments Comments (0) | Permalink | Send Send | Post to Twitter

18 June 2010

Frame Busting Code

It has been common in the past to include JavaScript "frame busting" or "frame killing" code to prevent a web site being displayed inside a frame (typically by someone else's frame).

Close-up photograph of engine machinery at the London Transport Museum, Covent Garden

It is also referred to as a frame killer frame buster. For those with an interest in coding, the type of thing I mean is something like:

<script type="text/javascript">
   if(top.location != location) {
	top.location.href = document.location.href;
   }
</script>

Originally this was mainly related to the concern of other sites framing your own content to make it look like their own. This was common where the frames site also used frames and had little branding on its content pages.

Well frames are used much less for this purpose nowadays but there are plenty of uses for frames in dynamic sites, and there are other problems to consider too such as Clickjacking identified by Robert Hansen and Jeremiah Grossman. So what is it best to use?

The Stanford Web Security Group has published a paper on Busting Frame Busting: A Study of Clickjacking Vulnerabilities at Popular Sites which examines existing frame busting code, ways it can be circumvented and includes a recommendation for current use. The paper is very readable, and easily digested if you are involved with web development.

So what are the recommendations? The paper suggests using the X-Frame-Options HTTP header, and creating a Firefox Content Security Policy, and adding code like:

<style type="text/css">
    html { visibility:hidden; }
</style>
<script language="javascript" type="text/javascript">
    if ( self == top ) {
	document.documentElement.style.visibility='visible';
    } else {
	top.location = self.location;
    }
</script>

This requires JavaScript to be supported and enabled. This may be an acceptable assumption if the site itself relies on JavaScript. But the code uses CSS to blank the content and JavaScript to make it visible, meaning that it could be inaccessible by some (many?) users. The paper's authors believe the code does not significantly alter page rendering or load time. The code is not guaranteed to be a secure approach to frame busting but the authors believe it is the best approach currently.

There is of course no harm in having target="_top" in all hyperlinks and forms, and using the BASEHREF tag and/or full URL in hyperlinks and form actions. If you allow parts of your site to be framed by your own or other web sites, you will need to be more careful how all these anti-framing techniques are applied.

However, I think there could be an adverse effect on public content search engine ranking, due to the use of content hiding, and I do not believe this risk has been examined. If the JavaScript code is used on content which is not meant to be indexed (e.g. registration, log in, password reset and content meant for authenticated users only), this is no longer a risk.

Pass this information on to your development team and ask them what they are doing to protect your web site and its users from framing.

Posted on: 18 June 2010 at 10:25 hrs

Comments Comments (0) | Permalink | Send Send | Post to Twitter

04 June 2010

Web Application Security Whoops

I read the Following the White Rabbit blog which had a special series on web application security whoops in April. I've had too much else to write about, so only just got round to mentioning it here.

Photograph of the push button on an old bus used to request the driver to stop labelled 'PUSH ONCE'

If you haven't read all thirty of the month-long "Whoops" series, I'd recommend them to you. Many things can go wrong designing, developing, testing and verifying web applications, but my personal favourite whoops are:

Keep up-to-date with more web application incidents by subscribing to the Web Hacking Incident Database (WHID) RSS feed from the Web Application Security Consortium.

We can all learn from by sharing incident data.

Posted on: 04 June 2010 at 08:09 hrs

Comments Comments (0) | Permalink | Send Send | Post to Twitter

28 May 2010

Application Security in North East England

A special web application security meeting is being held at the School of Applied Sciences, Northumbria University in Newcastle upon Tyne on Wednesday 16th June.

Photograph of the River Tyne at Newcastle-upon-Tyne showing some of the many bridges crossing the river

In March Northumbria University became OWASP's first (and so far only) educational supporter in the UK, and joins a number of highly respected academic institutions around the world. This is perhaps not entirely unexpected due to the region's entrepreneurial culture, its digital renaissance in recent years, the area's highly skilled technical workforce and Northumbria University's proactive efforts to improve information security such as its innovative program for SMEs. Oh, and its a great area to live in.

The region has a well-developed support infrastructure for the digital industry including Codeworks Connect, AppNorth, Design Network North, Sunderland Software City, the Institute of Digital Innovation at Teesside University and One North East. Now, the Leeds/North chapter of the The Open Web Application Security Project (OWASP) is holding its first event in north east England hosted by Northumbria University.

There will be four talks on ENISA Common Assurance Maturity Model, Open Source Software Myths, SSL/TLS - Just When You Thought it was Safe to Return and OWASP AppSensor - The Self-Aware Web Application. I am presenting the first and last talks. The talks span compliance, network communication, configuration, verification and building security in. They will be of interest to digital entrepreneurs, owners of software start-up companies, computing and design students, as well as software architects, designers, developers, testers and information system auditors.

The event is free but you need to register to attend.

Posted on: 28 May 2010 at 08:00 hrs

Comments Comments (0) | Permalink | Send Send | Post to Twitter

21 May 2010

PDF Information Leakage

Like many other document and files on your web site, PDFs can leak information in more than one way. Apart from the normal content, there is often meta data, information from previous versions and sometimes, links to internal resources.

Partial image of the beginning of the Financial Services Authority (FSA) template for letters alerting people to the risk of fraud - taken from the public document at http://www.fsa.gov.uk/pubs/press/operation_domingo.pdf - showing the FSA logo at the top right and the text '19 May 2010... Dear ..., This is a warning - you may be targeted by fraudsters I'm writing to you from the Financial Services Authority (FSA) to warn you that your name has been identified on a list currently being used by share fraudsters. These fraudsters, commonly known as boiler rooms, may contact you by telephone with offers to buy worthless shares.  Companies should never call you out of the blue offering to buy or sell shares. Please do not take up...'

On Wednesday, the Financial Services Authority (FSA) reported they had acquired a list of 38,000 names, addresses and telephone number that boiler rooms were using to target potential investors in worthless shares. The FSA wrote a letter to all the people listed. They also published the letter's outline format as a PDF. Unfortunately four enabled hyperlinks in the document do not reference the www.fsa.gov.uk website as intended, but instead a file on someone's computer, probably at the FSA.

Partial image of the of the FSA's template after clicking on an embedded hyperlink with a pop-up alert saying the link goes to 'D:\Documents and Settings\JMCNICHOL\Local Settings\JMCNICHOL\Local Settings\Temporary Internet Files\OLK9\www.fsa.gov.uk\Pages\Doing\Regulated\Law\Alerts\form.shtml'

Oh dear. Nothing too serious this time, but everything that is published should be checked for validity before release, and verified after publication. This should include all information, not just the normal visual content. The FSA should know better. Publishing to print (e.g. the letters) removes some of this additional information where publishing to an electronic format (e.g. PDF) doesn't always. All publishing should follow standard procedures and approvals processes should include checks for additional information.

Embedded data may leak business information (e.g. previous changes, authors' comments, file paths, account names, intellectual property) or personal data (e.g. location data, names), and possibly give malicious users information that will help them exploit the organisation's systems.

Also, some good news for the FSA, it has survived the change of government.

Posted on: 21 May 2010 at 07:54 hrs

Comments Comments (0) | Permalink | Send Send | Post to Twitter

23 April 2010

Misuse of Privileged Database Accounts

Privileged database accounts should generally not be used by web applications. It is a very common problem but verifying this often requires access to the servers or a copy of the web site's configuration information or database. However, sometimes you are given a big clue—like this order acknowledgement email I received on Tuesday.

Partial screen capture from the order acknowledgement email from an online ecommerce website with the text 'Database Administrator' next to the label 'Sales Agent' - the image also includes other masked details of the order dated 20th April 2010

Now that's interesting. This makes me wonder if sales orders placed manually, say by telesales staff, have staff names appearing here. But via the e-commerce site "Database Administrator" (DBA) is entered. This could indicate the account name being used by the online system to connect to the database.

It may not be a vulnerability, but it is un-necessary information to give to customers. Even if it is a vulnerability, it may not be exploitable. There may be no technical and business impacts. But let's imagine there is a problem.

There is almost certainly no need for this function, or the rest of the web site, to use what is probably a highly privileged database account. The account may have access to many more fields, tables, views, procedures, schemas, etc than are necessary for the business process. Whilst it would be impossible for most web sites to use different accounts (connection strings) for every use, it is often possible to have a small number of accounts, such as:

  • unauthenticated public user
  • registration/log-on/log out/password reset
  • authenticated users
  • content editors
  • content publishers
  • site administrators
  • logging (e.g. usage trends, audit trail, security log)
  • scheduled application tasks.

Any people who need direct access to the database (e.g. to extract other data, or alter the schema) should have their own personal account, and mustn't use the above or DBA accounts.

These should then only have access to the appropriate methods and database assets necessary for their role. This would mean for example, a dangerous function could not be used in the database. Or, that even if a public page could be exploited by SQL injection, it would be difficult to obtain access to the database schema or extract data limited to authenticated users (this does NOT prevent SQL injection, but may partly mitigate the effects). Similarly, if the account used by logging only has INSERT permissions to a subset of tables and no other application account has access, it's going to be much harder to modify or delete log entries accidentally or maliciously.

Therefore, build database roles into your web site's design, and enforce permissions appropriately through the code. When combined with server and database hardening, it will help protect the application and your business.

Posted on: 23 April 2010 at 08:33 hrs

Comments Comments (0) | Permalink | Send Send | Post to Twitter

20 April 2010

Moderate User-Generated Content But At Your Own Risk

A recent High Court ruling has reconfirmed the situation that pre or post moderation of user-submitted content may make a site owner liable for the material.

Photograph of a vandalised white board where a YouTube website address has been written on with a permanent marker pen and an attempt has been made unsuccessfully to remove the text

Whether user-generated content is unlawful, offensive or inappropriate such as comment spam (i.e. a danger to the web site, its users or their computer equipment), the advice appears to be not to do anything until a complaint is received, and then block or remove the content expeditiously. Although the meaning of content may still be an issue, the ability for users to submit links and other formatting should certainly be automatically prevented in most cases. That "just" leaves the unlawful and offensive content to deal with. Use of user registration, identity verification, logging and CAPTCHAs can help, but cannot prevent such content being added. It's still a big issue.

Most web site owners will not contemplate unmoderated user-generated content and this means that technical controls are not sufficient. The moderators need training, guidance and escalation procedures with good legal advice backup to ensure the content is suitable, appropriate and lawful. Users of the web site should understand what is acceptable and opt in to appropriate terms of use.

A full description and analysis was posted on the IT and e-commerce legal advice web site Out Law.

Posted on: 20 April 2010 at 08:17 hrs

Comments Comments (2) | Permalink | Send Send | Post to Twitter

More Entries

Preventative : Web Security, Usability and Design
ISO/IEC 18004:2006 QR code for http://clerkendweller.com

Requested by 38.107.191.106 on Friday, 10 September 2010 at 17:46 hrs (London date/time)

Please read our terms of use and obtain professional advice before undertaking any actions based on the opinions, suggestions and generic guidance presented here. Your organisation's situation will be unique and all practices and controls need to be assessed with consideration of your own business context.

Terms of use http://www.clerkendweller.com/page/terms
Privacy statement http://www.clerkendweller.com/page/privacy
© 2008-2010 clerkendweller.com