public function accessRights($resource, $role, $action)
{
$identity = Zend_Auth::getInstance()->getIdentity();
$resmodel = new App_Model_Users();
$this->resourceid = $resmodel->getResource($resource);
$this->roleid = $resmodel->getRole($role);
$db = Zend_Db_Table::getDefaultAdapter();
$access = $db->fetchOne("SELECT \n a.activity_id as activity_id\n FROM \n ob_grantactivites a,\n ob_subactivity b\n where a.submodule_id='" . $this->resourceid . "' and \n a.grant_id='" . $this->roleid . "' and \n a.activity_id = b.activity_id and\n b.activity_description = '" . $action . "'");
if ($access['activity_id']) {
$accessid = 1;
return $accessid;
} else {
$accessid = 0;
return $accessid;
}
}
