setup security and options

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Contents: __setup_security_and_options.sql
-- Statement count: 442
--
-- This script file reloads a database that was unloaded using "dbunload".
--
-- (Version:  17.0.11.7821)
--
 
 
****************** WARNING *******************************
*                                                        *
* This file contains USER definitions WITH removed       *
* password VALUES.                                       *
* It should NOT be used TO CREATE a NEW DATABASE.        *
*                                                        *
****************** WARNING *******************************
 
 
-- Database file: /srv/iqx/commentdb/IQX.db
-- Database CHAR collation: UTF8BIN, NCHAR collation: UTF8BIN
-- Connection Character Set: UTF-8
--
-- CREATE DATABASE command: CREATE DATABASE '/srv/iqx/commentdb/IQX.db' LOG ON '/srv/iqx/commentdb/IQX.log' PAGE SIZE 8192 COLLATION 'UTF8BIN(CaseSensitivity=Ignore)' NCHAR COLLATION 'UTF8BIN(CaseSensitivity=Ignore)' ENCRYPTED ON KEY '***' ALGORITHM 'AES256' BLANK PADDING OFF JCONNECT OFF CHECKSUM ON DBA USER '***' DBA PASSWORD '***' SYSTEM PROC AS DEFINER ON KEY DERIVATION ITERATIONS 2
--
 
 
SET OPTION date_order          = 'YMD'
GO
 
 
SET OPTION PUBLIC.preserve_source_format = 'OFF'
GO
 
 
SET TEMPORARY OPTION tsql_outer_joins = 'ON'
GO
 
 
SET TEMPORARY OPTION st_geometry_describe_type = 'binary'
GO
 
 
SET TEMPORARY OPTION st_geometry_on_invalid = 'Ignore'
GO
 
 
SET OPTION PUBLIC.reserved_keywords = ''
GO
 
 
-------------------------------------------------
--   Create dbspaces
-------------------------------------------------
 
 
-------------------------------------------------
--   Create ldap servers
-------------------------------------------------
 
 
-------------------------------------------------
--   Create login policies
-------------------------------------------------
 
 
-------------------------------------------------
--   Create users
-------------------------------------------------
 
GRANT CONNECT TO "dba"
GO
 
 
GRANT CONNECT TO "pears"
GO
 
 
GRANT CONNECT TO "IQXNet"
GO
 
 
GRANT CONNECT TO "FOXHOUND"
GO
 
 
-------------------------------------------------
--   Create role definitions
-------------------------------------------------
 
CREATE ROLE FOR USER "pears"
GO
 
 
CREATE OR REPLACE ROLE "COCKPIT_ROLE"
GO
 
 
CREATE OR REPLACE ROLE FOR USER "pears" WITH ADMIN ONLY "SYS_MANAGE_ROLES_ROLE"
GO
 
 
CREATE OR REPLACE ROLE "COCKPIT_ROLE" WITH ADMIN ONLY "SYS_MANAGE_ROLES_ROLE"
GO
 
 
GRANT DELETE ANY TABLE TO "SYS_RUN_PROFILER_ROLE" WITH NO ADMIN OPTION
GO
 
 
GRANT SET ANY SYSTEM OPTION TO "FOXHOUND" WITH NO ADMIN OPTION
GO
 
 
GRANT READ CLIENT FILE TO "dba" WITH NO ADMIN OPTION
GO
 
 
GRANT MANAGE ANY DBSPACE TO "FOXHOUND" WITH NO ADMIN OPTION
GO
 
 
GRANT DROP CONNECTION TO "FOXHOUND" WITH NO ADMIN OPTION
GO
 
 
GRANT DROP CONNECTION TO "COCKPIT_ROLE" WITH NO ADMIN OPTION
GO
 
 
GRANT MONITOR TO "FOXHOUND" WITH NO ADMIN OPTION
GO
 
 
GRANT MONITOR TO "COCKPIT_ROLE" WITH NO ADMIN OPTION
GO
 
 
GRANT BACKUP DATABASE TO "COCKPIT_ROLE" WITH NO ADMIN OPTION
GO
 
 
GRANT SERVER OPERATOR TO "FOXHOUND" WITH NO ADMIN OPTION
GO
 
 
GRANT SERVER OPERATOR TO "COCKPIT_ROLE" WITH NO ADMIN OPTION
GO
 
 
GRANT ACCESS DISK INFORMATION TO "COCKPIT_ROLE" WITH NO ADMIN OPTION
GO
 
 
GRANT ROLE "SYS_AUTH_DBA_ROLE" TO "dba" WITH ADMIN OPTION WITH NO SYSTEM PRIVILEGE INHERITANCE
GO
 
 
GRANT ROLE "SYS_AUTH_DBA_ROLE" TO "dbo" WITH ADMIN OPTION WITH NO SYSTEM PRIVILEGE INHERITANCE
GO
 
 
GRANT ROLE "SYS_AUTH_DBA_ROLE" TO "pears" WITH ADMIN OPTION WITH NO SYSTEM PRIVILEGE INHERITANCE
GO
 
 
GRANT ROLE "SYS_AUTH_RESOURCE_ROLE" TO "dba" WITH NO SYSTEM PRIVILEGE INHERITANCE
GO
 
 
GRANT ROLE "SYS_AUTH_RESOURCE_ROLE" TO "dbo" WITH NO SYSTEM PRIVILEGE INHERITANCE
GO
 
 
GRANT CREATE ON "system" TO "PUBLIC"
GO
 
 
GRANT CREATE ON "temporary" TO "PUBLIC"
GO
 
 
GRANT EXECUTE ON "pears"."IQXNetTemplateChoiceList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."IQXNetTemplateGradeList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetBlobPermitted" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateValidPersonID" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCanUploadVacancy" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientShiftCancelReasons" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDebtorsDaySalesOutstanding" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetErrorHandler" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetFavouriteTitle" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetFilePermitted" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetGetEmail" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetGetPlacementid" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetGetVacancySiteDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetHasPermission" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetJSString" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetLongQuestAnswer" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOrderReasonList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerJobRateList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerTimesheetLists" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetPopulateComplianceTable" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetQuestionOwnerID" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetShiftDateTime" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetStringToTimestamp" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTempShiftStatusString" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetEndDate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetVacancyHasRateScript" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetVacancyRoleAllowed" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetValidateEmailAddress" TO "IQXNet"
GO
 
 
SET TEMPORARY OPTION force_view_creation='ON'
GO
 
 
SET TEMPORARY OPTION force_view_creation='OFF'
GO
 
 
GRANT EXECUTE ON "dba"."login_create_variables" TO "PUBLIC"
GO
 
 
GRANT EXECUTE ON "pears"."NetActionDialogGetDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyAdditionalComments" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCandidateAdd" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCandidateCreate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCandidateProgress" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCandidateProgressHistory" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCandidates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCandidateStatusChoices" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCandidateSubmit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCandidatesWithPlacement" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCompanyStatusSelect" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyContact" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyContactSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCurrentRequirementAdditionalComments" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCurrentRequirementCandidates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCurrentRequirementCandidateSubmit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCurrentRequirementConfirmInterest" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCurrentRequirementCount" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyCurrentRequirementSearch" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyProvTimesheets" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyRejectCandidateReason" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyStandardDocumentList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyVacancies" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyVacancyNotes" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAgencyVacancyNotesUpdate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAlreadyApplied" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAPIProc" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAPIProcs" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAPIProcSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAssignmentDatasheet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetAudit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCalendarShifts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandCheckLoginStatus" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateAddEventsMultiDay" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateAddEventsOneDay" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateAddToShortlist" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateAssignmentDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateBankDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateBankDetailsSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateCalendar" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateCalendarSave" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateCompliance" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateCountUnacceptedShifts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateCreatePopup" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateCreateRegistration" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDepartmentRegister" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDiary" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDiaryActionSave" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDiaryAdd" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDiaryAddMultipleEvents" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDiaryMultiAdd" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDiaryReasons" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDisplayHolidayPay" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDivisionID" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDivisionRegister" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDocuments" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDocumentsAboutToExpire" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDocumentsFiltered" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateDoTermsAndConditions" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateEmploymentHistory" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateGetJobsAppliedFor" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateGetRegistrationComplete" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateLinkedRecords" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateP45sList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateP60sList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidatePayslipList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidatePersonHeadline" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidatePersonID" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidatePersonWebHeadline" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateProfile" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateProfileBank" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateProfileSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateProfileSetBank" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateProvTimesheetCount" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateProvTimesheetForApprovalCount" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateProvTimesheetForAuthoriseCount" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidatePublicProfile" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateRegDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateRegister" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateRegisterAdditionalInserts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateRegisterPreCheck" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateRegistration" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateRegistrations" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateSaveQuestions" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateSetRegistrationComplete" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateShiftBook" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateShifts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateShiftTemplates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateShortlistedJobs" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateSourceSelect" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateState" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateTaxCodeDropdown" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandidateTaxMethodDropdown" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCandProvTimesheets" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCheckLoginExists" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientAddMultipleShifts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientAddShifts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientAddShiftsMultiDay" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientAddShiftsMultiWeek" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientAddShiftsOneDay" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientAddShiftsWeek" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientAddSingleShift" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientAddVacancies" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientCandidatesPossibleForShift" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientCandidateStatusUpdate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientCandidateSubmit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientCombinedRequirementTemplates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientContact" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientContactSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientContracts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientContractVacancyDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientCreateBooking" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientCreatePopup" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientCurrentRequirement" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientDatedPreviousEmployees" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientDatedPreviousEmployeesFiltered" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientEmployeeList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientInvoiceList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientInvoiceTotal" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientPermanentRequirements" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientPreviousEmployeeJobs" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientPreviousEmployees" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientProvTimesheets" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientRejectCandidateReason" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientRequirementDocuments" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientRequirementList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientRequirementShortList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientRequirementShortListPlaced" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientRequirementSiteDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientRequirementSiteDetailsUpdate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientRequirementStatusFilter" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientRequirementTemplates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientRequirementVerifiedCandidates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientShiftCancelReasonsOuter" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientShiftDetailsTemplates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientShiftOrderReasons" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientShifts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientShiftTemplate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacancies" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacancies2" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacanciesCandidateHistory" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacanciesExtended" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacanciesLineStatusUpdate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacanciesLineTimesUpdate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacanciesPaging" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacanciesShortlistAction" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacanciesSingleLineRefresh" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacancySuggestCandidate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacancyTemplate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetClientVacancyTemplates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCompliance" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetContactList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetContactRights" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetContactRightsSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetContactSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetCreateAvailabilityContactEvent" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDashboardObjects" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDashboardObjectSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDBSetup" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDBSetupPrerequisites" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDefineProcs" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDeleteWebReference" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDepartmentList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDivisionList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDivisionPopup" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDockerGetConfig" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDockerGetPageText" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetDoSkillsMatch" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetFavourites" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetFileList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetForgottenPassword" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetGetRegRequired" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetGetSwitches" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetGetWebEmail" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetGetWebReferences" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetGetWebUserIDs" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetIncomingApplications" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NETITSP45" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetITSP60" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NETITSPayslipHolidayPay" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NETITSPayslips" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NETITSPayslipsDeductions" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NETITSPayslipsHours" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetMessage" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetNumberProvTimesheet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOLEDocuments" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerAccountDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerAccountEdit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerActionDialog" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerAddToFavs" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerAggregateSearch" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCandidateAppointments" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCandidateBankEdit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCandidateDiary" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCandidateProfileEdit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCandidateProfileSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCandidateSearch" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCandidateSelect" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCandidateSetBank" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCandidateSubmit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCompanyDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCompanyEdit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCompanySalesStatuses" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCompanySearch" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerCompanySelect" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerConsultantList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerContactEvents" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerContactEventsSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerContactList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerContactSearch" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerContactSelect" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerDashboardDiaryCount" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerDashboardDiaryCountWeek" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerDashboardDiaryNext" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerDiary" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerDiaryCount" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerDiarySet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerEmployeeDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerEmployeeEdit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerFavourites" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerFavouritesAdd" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerFavouritesAll" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerFavouritesRemove" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerGetContactEventOutcome" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerGetContactEventType" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerGetFavTitles" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerIsFav" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerJobRateListOuter" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerPageTitle" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerPayRateEdit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerPlacementList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerProvTimesheets" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRateDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRegistration" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRegistrations" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRemoveFromFavs" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRequirementConsultantList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRequirementContracts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRequirementList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRequirementShifts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRequirementShortList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRequirementShortListPlaced" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRequirementStatusFilter" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerRequirementsTempdeskList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerSetCompanySalesStatus" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerSettingsGetRight" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerSettingsGetRightAllowed" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerSettingsGetRightAssigned" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerSettingsGetRightDefault" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerSettingsGetSwitches" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerSettingsSaveRightsAllowed" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerSettingsSaveRightsAssigned" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerSettingsSaveRightsDefault" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerSettingsSaveSwitches" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerShortlistedJobs" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerStaffCompanySalesStatus" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerTimesheetCandidateSearch" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerTimesheetCreate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerTimesheetListsOuter" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerTreeSource" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerVacancyDetails" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerVacancyEdit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetOwnerVacancySuggestCandidate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetPersonProfile" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetPersonProfileSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetPersonShifts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProduceComplianceView" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetComplete" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetExpenseLineCreate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetExpenseLineDelete" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetExpenseLineReceiptUpload" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetExpenseRatesSelect" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetRates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetRateSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetRatesExtended" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheets" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetSendForApproval" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetSetTheirRef" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetShiftAdd" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetShiftCancel" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetShiftCheckDates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetShifts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetShiftSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetShiftsSelect" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetTimes" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetProvTimesheetTimeSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetQuestionAudit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetQuestionGroupCountForDepartment" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetQuestionnaire" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetQuestionnaire2" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetQuestSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReference" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReferenceSet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportAgedDebtors" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportCandidateProgressHistory" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportClientStats" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportCombo_ClientSite" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportCombo_department" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportCombo_gender" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportConsultantDailies" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportConsultantStats" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportDebtorsDetailed" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportDoubtfulDebtors" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportFulfilment" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportGenevaShiftsAndInvoices" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportGrossTurnover" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportMetadata" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportPersonHEExpiryDates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportProvTimesheetLines" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportProvTimesheets" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportProvTimesheetsExpanded" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportReceipts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReports" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportShiftFill" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportShiftHours" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportSpend" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportTimesheetLines" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportTimesheets" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportTimesheetsExpanded" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportUniTimesheetLines" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportUniTimesheets" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportVacShiftsCountOfHoursIncSite" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetReportVacShiftsCountOfHoursIncSiteLines" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetResetPassword" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetSearchDateOffsetValues" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetSearchJobs" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetSendMessageToCandidate" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetSetShiftplanCascade" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetSetVacancyCascade" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetSetWebReference" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetShiftTypes" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetStandardDocumentList" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTestGetStaff" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTestLoop" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTestSetup" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetApprove" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetHeader" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetIDFromSerialNumber" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetRates" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheets" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetsAll" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetsAllFiltered" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetsAllFilteredExtended" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetsForApproval" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetShifts" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetsTickInvoiced" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetTimesheetTimes" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetUpdatePermissions" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetUploadTypes" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetVacancyCancel" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetVacancyConfirm" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetVacancyDocuments" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetVacancyFill" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."NetWizardGetPage" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."SoftNetAssignmentDatasheet" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."_NetPushNotificationsDeviceAdd" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."_NetPushNotificationsDeviceEdit" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."_NetPushNotificationsDeviceRemove" TO "IQXNet"
GO
 
 
GRANT EXECUTE ON "pears"."_NetPushNotificationsDevices" TO "IQXNet"
GO
 
 
-------------------------------------------------
--   Create options
-------------------------------------------------
 
SET OPTION date_order =
GO
 
 
SET OPTION PUBLIC.preserve_source_format =
GO
 
 
SET OPTION "PUBLIC"."ansi_substring"='off'
GO
 
 
SET OPTION "PUBLIC"."database_authentication"='Company=IQX;Application=IQX;Signature=010fa55157edb8e14d818eb4fe3db41447146f1571g60e8de06c19e55b74a0f0c7d0982fabcfcbf7fa7'
GO
 
 
SET OPTION "PUBLIC"."encrypt_aes_random_iv"='On'
GO
 
 
SET OPTION "PUBLIC"."login_procedure"='dba.login_create_variables'
GO
 
 
SET OPTION "PUBLIC"."max_statement_count"='200'
GO
 
 
SET OPTION "PUBLIC"."min_password_length"='0'
GO
 
 
SET OPTION "PUBLIC"."prefetch"='On'
GO
 
 
SET OPTION "PUBLIC"."preserve_source_format"='ON'
GO
 
 
SET OPTION "PUBLIC"."prevent_article_pkey_update"='Off'
GO
 
 
SET OPTION "PUBLIC"."RememberLastStatement"='on'
GO
 
 
SET OPTION "PUBLIC"."sr_timestamp_format"='hh:nn:ss.Ssssss yyyy/mm/dd'
GO
 
 
SET OPTION "PUBLIC"."string_rtruncation"='off'
GO
 
 
SET OPTION "PUBLIC"."subsume_row_locks"='Off'
GO
 
 
SET OPTION "dba"."allow_read_client_file"='ON'
GO