Cognos cube security can be set by the cube administrator, which cannot, by the way, override the database security in cases where the user in question accesses the database, either because the cube is in a database or during drill through.
Sometimes the grass is greener on the other side because there is more manure there - original.