CREATE GROUP ACCGROUP#
GRANT SELECT ON TableLookups TO ACCGROUP#
GRANT SELECT ON OperatorLogIns TO ACCGROUP#
GRANT SELECT ON FreeText TO ACCGROUP#
GRANT SELECT ON FiscalPeriods TO ACCGROUP#
GRANT SELECT ON CBPayeesDrawers TO ACCGROUP#
GRANT SELECT ON BOBankAddress TO ACCGROUP#
GRANT SELECT ON Postcodes TO ACCGROUP#
GRANT SELECT ON BOBankBranch TO ACCGROUP#
GRANT SELECT ON ContactNames TO ACCGROUP#
GRANT SELECT ON ForexRates TO ACCGROUP#
GRANT SELECT ON TaxRates TO ACCGROUP#
GRANT SELECT ON AutoNumbers TO ACCGROUP#
GRANT ALL ON LedgerHold TO ACCGROUP#
GRANT SELECT ON CarReg TO ACCGROUP#
GRANT SELECT ON Addresses TO ACCGROUP#
GRANT SELECT ON TelephoneNumbers TO ACCGROUP#
GRANT SELECT ON NameLink TO ACCGROUP#
GRANT SELECT ON NameXref TO ACCGROUP#
GRANT SELECT ON Names TO ACCGROUP#
GRANT SELECT ON Folios TO ACCGROUP#
GRANT SELECT ON FolioCrossRef TO ACCGROUP#
GRANT SELECT ON FolioLines TO ACCGROUP#
GRANT SELECT ON FolioLnDetails TO ACCGROUP#
GRANT SELECT ON FolioLnTaxes TO ACCGROUP#
GRANT SELECT ON TelCallDetails TO ACCGROUP#
GRANT SELECT ON PostingElements TO ACCGROUP#
GRANT SELECT ON PkgCvrgCrossRef TO ACCGROUP#
GRANT SELECT ON TelephoneExtension TO ACCGROUP#
GRANT SELECT ON TaxCrossReference TO ACCGROUP#
GRANT SELECT ON RateCodes TO ACCGROUP#
GRANT SELECT ON RatePeriods TO ACCGROUP#
GRANT SELECT ON RateCharges TO ACCGROUP#
GRANT SELECT ON PkgCvrgSetUp TO ACCGROUP#
GRANT SELECT ON AllowanceUsage TO ACCGROUP#
GRANT SELECT ON SalesInfo TO ACCGROUP#
GRANT SELECT ON Hotels TO ACCGROUP#
GRANT SELECT ON ReservationHeader TO ACCGROUP#
GRANT SELECT ON NameIndex TO ACCGROUP#
GRANT SELECT ON BookingLines TO ACCGROUP#
GRANT SELECT ON AlternateHotels TO ACCGROUP#
GRANT SELECT ON DepositPolicies TO ACCGROUP#
GRANT SELECT ON CancelReason TO ACCGROUP#
GRANT SELECT ON NoSellReason TO ACCGROUP#
GRANT SELECT ON StayDetails TO ACCGROUP#
GRANT SELECT ON RoomSetup TO ACCGROUP#
GRANT SELECT ON AvailHeader TO ACCGROUP#
GRANT SELECT ON AvailUsage TO ACCGROUP#
GRANT SELECT ON RoomAssignment TO ACCGROUP#
GRANT SELECT ON HouseAccount TO ACCGROUP#
GRANT SELECT ON GeneralStatistics TO ACCGROUP#
GRANT SELECT ON StatisticsXref TO ACCGROUP#
GRANT SELECT ON ConsolStatistics TO ACCGROUP#
GRANT SELECT ON CashReport TO ACCGROUP#
GRANT SELECT ON BrochureRequests TO ACCGROUP#
GRANT SELECT ON SalesCallHistory TO ACCGROUP#
GRANT SELECT ON CNADetails to ACCGROUP#
GRANT SELECT ON RateCrossRef TO ACCGROUP#
GRANT SELECT ON ForeignExTranx TO ACCGROUP#
GRANT SELECT ON Messages TO ACCGROUP#
GRANT SELECT ON DepositDetails TO ACCGROUP#
GRANT SELECT ON DepositRequests TO ACCGROUP#
GRANT SELECT ON Guests TO ACCGROUP#
GRANT SELECT ON GroupMaster TO ACCGROUP#
GRANT SELECT ON GrpBookLineHist TO ACCGROUP#
GRANT SELECT ON ReservationLink TO ACCGROUP#
GRANT SELECT ON PoliceDetails TO ACCGROUP#
GRANT SELECT ON Companies TO ACCGROUP#
GRANT SELECT ON RevenueAnalysis TO ACCGROUP#
GRANT SELECT ON ConfirmationsRcvd TO ACCGROUP#
GRANT SELECT ON MaintenanceHeader TO ACCGROUP#
GRANT SELECT ON AdditionalRates TO ACCGROUP#
GRANT SELECT ON CommissionDetails TO ACCGROUP#
GRANT SELECT ON TelephoneCharges TO ACCGROUP#
GRANT SELECT ON LedgerReferences TO ACCGROUP#
GRANT SELECT ON WakeUpsAndNewspapers TO ACCGROUP#
GRANT SELECT ON ChaseDetails TO ACCGROUP#
GRANT SELECT ON AncilliaryGuestData TO	ACCGROUP#
GRANT SELECT ON AncilliaryResData TO ACCGROUP#
GRANT SELECT ON RateGrpCloseOuts TO ACCGROUP#
GRANT SELECT ON BookingHistoryLog TO ACCGROUP#
GRANT SELECT ON FinancialEODs TO ACCGROUP#
GRANT SELECT ON AdditionalConfig TO ACCGROUP#
GRANT SELECT ON EventDetails TO ACCGROUP#
GRANT SELECT ON CANominalCodes TO ACCGROUP#
GRANT SELECT ON CAPeriods TO ACCGROUP#
GRANT SELECT ON CAPeriodAccum TO ACCGROUP#
GRANT SELECT ON BOTaxDefinition TO ACCGROUP#
GRANT SELECT ON CATaxNLcode TO ACCGROUP#
GRANT SELECT ON CAdictionary TO ACCGROUP#
GRANT SELECT ON NLLedgerSetUp TO ACCGROUP#
GRANT SELECT ON NLFormattedJnl TO ACCGROUP#
GRANT SELECT ON NLBatches TO ACCGROUP#
GRANT SELECT ON NLTransactions TO ACCGROUP#
GRANT SELECT ON NLReportDesign TO ACCGROUP#
GRANT SELECT ON NLReportData TO ACCGROUP#
GRANT SELECT ON SLfolioLimits TO ACCGROUP#
GRANT SELECT ON NLpurgedBatches TO ACCGROUP#
GRANT SELECT ON NLpurgedTrans TO ACCGROUP#
GRANT SELECT ON CBCashBookSetUp TO ACCGROUP#
GRANT SELECT ON CBBatches TO ACCGROUP#
GRANT SELECT ON CBdictionary TO ACCGROUP#
GRANT SELECT ON CBRecTransXref TO ACCGROUP#
GRANT SELECT ON CBStatementPages TO ACCGROUP#
GRANT SELECT ON CBChequeIssue TO ACCGROUP#
GRANT SELECT ON CBBankRecData TO ACCGROUP#
GRANT SELECT ON BODirectDebits TO ACCGROUP#
GRANT SELECT ON BOLedgerAccount TO ACCGROUP#
GRANT SELECT ON BOTransDetails TO ACCGROUP#
GRANT SELECT ON BOBatches TO ACCGROUP#
GRANT SELECT ON BOLedgerSetUp TO ACCGROUP#
GRANT SELECT ON BOTransSummary TO ACCGROUP#
GRANT SELECT ON BOPaymentXref TO ACCGROUP#
GRANT SELECT ON PLChequeXref TO ACCGROUP#
GRANT SELECT ON BOdictionary TO ACCGROUP#
GRANT SELECT ON BOStatementDesign TO ACCGROUP#
GRANT SELECT ON DepositPaymentMethod TO ACCGROUP#
GRANT SELECT ON DepositTaxXref TO ACCGROUP#
GRANT SELECT ON VoucherXref TO ACCGROUP#
GRANT SELECT ON MailshotHistory TO ACCGROUP#
GRANT SELECT ON GuestMergeHistory TO ACCGROUP#
GRANT SELECT ON OperatorID TO ACCGROUP#
GRANT SELECT ON FiscalPeriodType TO ACCGROUP#
GRANT SELECT ON Countries TO ACCGROUP#
GRANT SELECT ON Currencies TO ACCGROUP#
GRANT SELECT ON BankCode TO ACCGROUP#
GRANT SELECT ON MarketAreas TO ACCGROUP#
GRANT SELECT ON ExchangeType TO ACCGROUP#
GRANT SELECT ON LoginResult TO ACCGROUP#
GRANT SELECT ON TaxCode TO ACCGROUP#
GRANT SELECT ON TelecomRecordTypes TO ACCGROUP#
GRANT SELECT ON ContactInterests TO ACCGROUP#
GRANT SELECT ON JobPositions TO ACCGROUP#
GRANT SELECT ON CompanyTypes TO ACCGROUP#
GRANT SELECT ON BookingMethods TO ACCGROUP#
GRANT SELECT ON SalesTerritories TO ACCGROUP#
GRANT SELECT ON SalesStatuses TO ACCGROUP#
GRANT SELECT ON ContactMethods TO ACCGROUP#
GRANT SELECT ON TAAssociations TO ACCGROUP#
GRANT SELECT ON SalesResponses TO ACCGROUP#
GRANT SELECT ON SalesFollowUps TO ACCGROUP#
GRANT SELECT ON Miscellaneous1 TO ACCGROUP#
GRANT SELECT ON Miscellaneous2 TO ACCGROUP#
GRANT SELECT ON CompanyInts1 TO ACCGROUP#
GRANT SELECT ON CompanyInts2 TO ACCGROUP#
GRANT SELECT ON HotelComments TO ACCGROUP#
GRANT SELECT ON HotelFeatures TO ACCGROUP#
GRANT SELECT ON HotelClasses TO ACCGROUP#
GRANT SELECT ON HotelGroups TO ACCGROUP#
GRANT SELECT ON HotelAreas TO ACCGROUP#
GRANT SELECT ON MarketSegments TO ACCGROUP#
GRANT SELECT ON Promotions TO ACCGROUP#
GRANT SELECT ON RoomFeatures TO ACCGROUP#
GRANT SELECT ON RoomClasses TO ACCGROUP#
GRANT SELECT ON RoomTypes TO ACCGROUP#
GRANT SELECT ON ResStatus TO ACCGROUP#
GRANT SELECT ON BkgLineStatus TO ACCGROUP#
GRANT SELECT ON NoSellCode TO ACCGROUP#
GRANT SELECT ON CxlReasonCode TO ACCGROUP#
GRANT SELECT ON ResCategories TO ACCGROUP#
GRANT SELECT ON BrochureStatus TO ACCGROUP#
GRANT SELECT ON ResComment TO ACCGROUP#
GRANT SELECT ON VIPStatuses TO ACCGROUP#
GRANT SELECT ON GuestInterests TO ACCGROUP#
GRANT SELECT ON FloorNumber TO ACCGROUP#
GRANT SELECT ON GuestComments TO ACCGROUP#
GRANT SELECT ON PostPayGroups TO ACCGROUP#
GRANT SELECT ON PostPaySections TO ACCGROUP#
GRANT SELECT ON PkgCvrgGroups TO ACCGROUP#
GRANT SELECT ON HKSection TO ACCGROUP#
GRANT SELECT ON MaintJobTypes TO ACCGROUP#
GRANT SELECT ON BrochureTypes TO ACCGROUP#
GRANT SELECT ON RoomStatus TO ACCGROUP#
GRANT SELECT ON HKCondition TO ACCGROUP#
GRANT SELECT ON Rates TO ACCGROUP#
GRANT SELECT ON StatsCollectors TO ACCGROUP#
GRANT SELECT ON DepositType TO ACCGROUP#
GRANT SELECT ON StatsRevenueType TO ACCGROUP#
GRANT SELECT ON Packages TO ACCGROUP#
GRANT SELECT ON CoverageCodes TO ACCGROUP#
GRANT SELECT ON RevAnalysisType TO ACCGROUP#
GRANT SELECT ON CashierShift TO ACCGROUP#
GRANT SELECT ON ExtensionCategory TO ACCGROUP#
GRANT SELECT ON GroupStatus TO ACCGROUP#
GRANT SELECT ON ConfirmationType TO ACCGROUP#
GRANT SELECT ON Residencies TO ACCGROUP#
GRANT SELECT ON StatsRecordType TO ACCGROUP#
GRANT SELECT ON AddlRateStatus TO ACCGROUP#
GRANT SELECT ON DepPolicyCode TO ACCGROUP#
GRANT SELECT ON ChaseReasons TO ACCGROUP#
GRANT SELECT ON BrochureLetterType TO ACCGROUP#
GRANT SELECT ON GuestPreferences TO ACCGROUP#
GRANT SELECT ON BrochureSource TO ACCGROUP#
GRANT SELECT ON InclusiveMeals TO ACCGROUP#
GRANT SELECT ON CACompanyCode TO ACCGROUP#
GRANT SELECT ON CAHotelCode TO ACCGROUP#
GRANT SELECT ON CADepartments TO ACCGROUP#
GRANT SELECT ON CAExpenseCode TO ACCGROUP#
GRANT SELECT ON CAOutletCode TO ACCGROUP#
GRANT SELECT ON CALegalCode TO ACCGROUP#
GRANT SELECT ON CAProjectCode TO ACCGROUP#
GRANT SELECT ON CASections TO ACCGROUP#
GRANT SELECT ON CAStatisticCode TO ACCGROUP#
GRANT SELECT ON CAPeriodStatus TO ACCGROUP#
GRANT SELECT ON CADepartmentTypes TO ACCGROUP#
GRANT SELECT ON NLTransType TO ACCGROUP#
GRANT SELECT ON NLTransStatus TO ACCGROUP#
GRANT SELECT ON PLAccountCategory TO ACCGROUP#
GRANT SELECT ON PLChaseReasons TO ACCGROUP#
GRANT SELECT ON PLSubCategory TO ACCGROUP#
GRANT SELECT ON PLPayMethod TO ACCGROUP#
GRANT SELECT ON PLTransType TO ACCGROUP#
GRANT SELECT ON PLAccountType TO ACCGROUP#
GRANT SELECT ON PLAccountStatus TO ACCGROUP#
GRANT SELECT ON SLAccountCategory TO ACCGROUP#
GRANT SELECT ON SLChaseReasons TO ACCGROUP#
GRANT SELECT ON SLSubCategory TO ACCGROUP#
GRANT SELECT ON SLPayMethod TO ACCGROUP#
GRANT SELECT ON SLTransType TO ACCGROUP#
GRANT SELECT ON SLAccountType TO ACCGROUP#
GRANT SELECT ON SLAccountStatus TO ACCGROUP#
GRANT SELECT ON CBPayMethod TO ACCGROUP#
GRANT SELECT ON CBTransType TO ACCGROUP#
GRANT SELECT ON CBTransStatus TO ACCGROUP#
GRANT SELECT ON CBApplication TO ACCGROUP#
GRANT SELECT ON CBTransSource TO ACCGROUP#
GRANT SELECT ON RateGroup TO ACCGROUP#