AdminGroup has these rights:
So this hopefully makes more sense.GRANT CONNECT TO "AdminGroup" IDENTIFIED BY ENCRYPTED '...snip'\ngo\nGRANT GROUP TO "AdminGroup"\ngo\nGRANT DBA TO "AdminGroup"\ngo
Hopefully there is enough here. If not ask for more. I want to see if I can make this work for another db. I just need to know how to wrap it.CREATE TABLE "AdminGroup"."abmc_account_internal"\n(\n "account_id" integer NOT NULL,\n "db_created_tms" timestamp NOT NULL,\n "db_modified_tms" timestamp NOT NULL,\n "modtimestamp_tms" integer NULL,\n "ending_balance_amt" numeric(20,5) NULL,\n "check_to_send_bool" bit NOT NULL,\n "special_type" smallint NULL,\n "cc_payment_account_id" integer NULL,\n "cc_payee_id" integer NULL,\n "service_charge_class_id" integer NULL,\n "interest_account_id" integer NULL,\n "interest_class_id" integer NULL,\n "service_charge_account_id" integer NULL,\n "last_statement_date" date NULL,\n "last_matched_trans_date" date NULL,\n "reconcile_statement_date" date NULL,\n "interest_date" date NULL,\n "service_charge_date" date NULL,\n "interest_amt" numeric(20,5) NULL,\n "service_charge_amt" numeric(20,5) NULL,\n "reconcile_statement_amt" numeric(20,5) NULL,\n "last_hand_doc" varchar(21) NULL,\n "cc_memo" varchar(100) NULL,\n "company_id" integer NULL,\n PRIMARY KEY ("account_id")\n)\ngo\nGRANT SELECT, INSERT, DELETE, UPDATE ON\n "AdminGroup"."abmc_account_internal" TO \n "UserGroup" FROM "AdminGroup"\ngo\nGRANT SELECT, INSERT, DELETE, UPDATE, ALTER, REFERENCES ON\n "AdminGroup"."abmc_account_internal" TO\n "AdminGroup" FROM "AdminGroup"\ngo