DROP TABLE TESTTABLE CASCADE CONSTRAINTS;
DROP SEQUENCE TESTTABLE_SEQ;
DROP ROLE TESTUSERROLE;

CREATE TABLE TESTTABLE (
  "ID" NUMBER(5,0) NOT NULL ENABLE,
  "Name" VARCHAR2(50 BYTE),
  CONSTRAINT "TESTID_PK" PRIMARY KEY ("ID") ENABLE );
CREATE SEQUENCE TESTTABLE_SEQ;
CREATE ROLE TESTUSERROLE;

GRANT SELECT, UPDATE, INSERT ON TESTTABLE TO TESTUSERROLE;
GRANT SELECT ON TESTTABLE_SEQ TO TESTUSERROLE;
GRANT TESTUSERROLE TO TESTUSER2;

DROP TABLE TESTTABLE succeeded.
DROP SEQUENCE TESTTABLE_SEQ succeeded.
DROP ROLE TESTUSERROLE succeeded.
CREATE TABLE succeeded.
CREATE SEQUENCE succeeded.
CREATE ROLE succeeded.
GRANT SELECT, succeeded.
GRANT SELECT succeeded.
GRANT TESTUSERROLE succeeded.