Monthly Archive: July 2009

EXCLUSIVE: Local authorities pioneer the first eco-towns 0

EXCLUSIVE: Local authorities pioneer the first eco-towns

20 July 2009 The eco-town programme has captured the imagination of local authorities says Kate Henderson from planning and housing charity, the Town and Country Planning Association (TCPA) Local authority led proposals in Whitehill-Bordon in Hampshire, St Austell (China Clay) in Cornwall, Rackheath in Norfolk and North West Bicester in Oxfordshire have been confirmed in national planning policy as locations for new eco-towns. These eco-developments will pioneer innovative design and low carbon infrastructure for greener living. According to Gordon Brown: “Eco-towns will help to relieve the shortage of affordable homes to rent and buy and to minimise the effects of climate change on a major scale.

They will provide modern homes with lower energy bills, energy efficient offices and brand new schools, community centres and services.” Speaking about the successful sites the Prime Minister added: “I am delighted that Whitehill-Bordon, St Austell, Rackheath and North West Bicester have all been chosen to be pioneers for these new green communities and I hope people will seize the opportunity to be at the forefront of Britain’s green revolution.” The Eco-town Planning Policy Statement (PPS) sets out the toughest ever sustainability standards for development and lays the foundations for further eco-town schemes to come forward. This charity is immensely proud that the policy advocates TCPA published standards for eco-towns. By sharing best practice and new innovation, eco-towns provide the opportunity to help communities in our existing towns and cities make a more informed and strategic response to climate change and sustainable housing growth.

Eco-town PPS sets out: the planning process eco-town developers will need to follow the eco-town standards – the standards any eco-town proposal will have to meet, such as providing a minimum amount of 40 per cent green space and 30 per cent of housing being affordable the list of locations currently assessed as having the potential to have an eco-town arrangements for monitoring implementation of the standards, as eco-town schemes are brought forward Alongside the plans for eco-towns, housing minister John Healey announced tougher new energy standards for all new homes from 2016 to be zero carbon and launched a review to combine the government’s climate change and renewable energy planning policy statements. Healey said: “Planning is at the heart of delivering our ambitious climate change targets. The scale of the challenge is now clear, as is the imperative to plan and design for a low carbon economy.

We will therefore review and combine the climate change and renewable energy PPSs, consulting in detail on proposals by the end of 2009.” Both the science and solutions that relate to climate change are moving at an unprecedented pace. The current planning policy framework on climate reflects the available thinking in 2007 before the Climate Change Act it also pre-dates the UK’s commitment to producing 15 per cent of total energy from renewables by 2020 and the challenging legally-binding ‘carbon budgets’, which require a reduction in greenhouse gas emissions of 34 per cent by 2020 and at least 80 per cent by 2050. Given the scale of the climate change challenge and the shift in acceptance that will be required to meet our renewable energy targets the TCPA believe that there is a clear need for updated national policy.

This policy should reflect the latest climate science and provide clearer specific guidance as to the weight to be given to climate change in planning. This will demand action from local authorities and their planners at the regional, sub-regional and city scales as well as at the community and neighbourhood scale where some of the greatest opportunities exist. That is why the TCPA are working in partnership with Friends of the Earth and a range of cross sector coalition partners to call for a new planning policy statement on climate change to help ensure that local authorities play their part in tackling climate change and that renewable energy targets are met.

The government’s commitment, both in the Renewable Energy Strategy (published on 15 July) and the announcements by the housing minister (16 July) to consult on a new combined climate change PPS by the end of 2009 are a clear indication that the government is listening to this important coalition and it is a powerful foundation for our future work.

Database security: personalized accounts at O.S.-level 0

Database security: personalized accounts at O.S.-level

Attended a workshop about Oracle database security (by Frits Hoogland 1 ), though the subject could also be named like O.S.-security of an Oracle Database . Most of the times the database will be installed by an oracle account, and all the DBA s are using this account for administrative purpose. Nothing wrong with that, but logging/auditing of this oracle account is modifyable (=useless) and who did what on this machine?

So it s quite understandable that an organization will choose for personalized, controlled accounts for DBA s. Quite scary for a DBA by the way, his kingdom and freedom is vanishing What follows is a template to setup such personalized account. Root create users and groups # groupadd -g 54321 oracle # groupadd -g 54322 oinstall # groupadd -g 54323 dba # groupadd -g 54324 oper # groupadd -g 54325 asm # useradd -d /home/oracle -m -g oracle -G dba,asm,users,oinstall -s /bin/bash -u 54321 -c Oracle software owner oracle For X-windows: grep the X-cookie, from server console: # env |grep XAUT > XAUTHORITY=/tmp/.gdmXXXXXX Make this cookie accessable for other users: # chmod 644 $XAUTHORITY Become oracle # su oracle Set XAUTHORITY again: $ export XAUTHORITY=/tmp/.gdmXXXXXX Install the software for the database: $ /oracle/sw/db.10.2.01/database/runInstaller > group DBA is UNIX DBA group. > group oinstall is inventory group.

After installation, remove the world rights from ORACLE_HOME (10g) # chmod -R o-rwx $ORACLE_HOME Configuration SUDO: Pass on ORACLE_HOME, by adding ORACLE_HOME to the env_keep setting: # visudo > Defaults env_keep= ORACLE_HOME COLORS DISPLAY .. < Grant access to oracle executables as oracle': # visudo > # entries to enable the dba group to do dba activities %dba ALL=(oracle) NOPASSWD: /oracle/db/*/bin/lsnrctl %dba ALL=(oracle) NOPASSWD: /oracle/db/*/bin/dbca %dba ALL=(oracle) NOPASSWD: /oracle/db/*/bin/netca %dba ALL=(oracle) NOPASSWD: /oracle/db/*/bin/emctl %dba ALL=(oracle) NOPASSWD: /oracle/db/*/bin/orapwd %dba ALL=(oracle) NOPASSWD: /oracle/db/*/bin/netmgr < Creating a personal account: # useradd -g users -G oracle,dba testuser Setting password: # passwd testuser Then logout as root, login as testuser. oracle needs to have access to testuser s MT-MAGIC-COOKIE: That s different for console and ssh: Console: $ chmod 644 $XAUTHORITY Ssh: $ cat ~/.Xauthroity > /tmp/xauth.$$ $ export XAUTHORITY=/tmp/xauth.$$ Then create a database (e.g. testdb ) as testuser’: $ sudo -u oracle /oracle/db/ After the installation the testuser is able to start and stop the database the normal way: $ export ORACLE_HOME=/oracle/db/ $ export ORACLE_SID=testdb $ /oracle/db/ / as sysdba SQL> startup But..

the listener has no SUID and/or GUID bits, so you have to use sudo: $ sudo -u oracle /oracle/db/ start Listener is updatable through netca . Logfile is readonly for testuser, needs rotation and cleaning. Auditing files needs cleaning too.

You may audit all sql of SYSDBA/SYSOPER through: SQL> alter system set audit_sys_operations=true scope=spfile; Beware: spfile and init.ora are READONLY.

References ^ Frits Hoogland (

The Moorings, Wells Next the Sea – British Holidays Direct 0

The Moorings, Wells Next the Sea – British Holidays Direct

Accommodation Ground floor Entrance to Sun Room leading to downstairs WC and Kitchen / Dining Room: The spacious kitchen and dining area is well equipped with a range cooker, dishwasher, fridge/freezer, washing macine, microwave, kettle, toaster and range cooker (gas hob). A full complement of cutlery, crockery and cooking utensils are provided. The dining area has a large table with 8 high backed dining chairs and a flat screen TV.

Door leading from Kitchen / Diner to the lovely decked area at the back of the property, with a large table and ample seating to enjoy the views. Utility Room: Washing machine & 2nd fridge/freezer. First floor Galleried Landing Sitting Room: A large, bright and airy L-shaped room, with two three-seater comfy sofas, coffee table, a big armchair and matching long footstool.

There is a flat screen 42″ TV, DVD & stereo and French doors which open onto a Juliette balcony to the front of the property. Master Bedroom: A charming room with a king-size bed, views out twowards the pinewoods and En-suite shower room with WC and pedestal hand basin. Second Floor Galleried landing with distant SEA VIEWS Double Bedroom: Lovely room with sloping ceilings, double bed, ample storage and windows to the front of the property.

Triple Room: A good sized room with three single beds, fitted wardrobe and bedside tables with lamps. Family Bathroom: Luxury family bathroom with bath, separate shower cubicle, WC & wash hand basin. Bed linen is provided.

Towels are provided at 5.00 per person. Gas Central Heating A Travel Cot & High Chair are available on request. Outside: There is off-road parking for one car inside the gate at the front of the property and further parking is available on the road within the development.

There is a paved and gravelled front entrance and decked area to the rear of the property.