create user unasync identified by Unasync123;
GRANT "PUBLIC","RESOURCE" to "unasync";
GRANT SELECT ON DBA_TABLES to unasync;
GRANT SELECT ON DBA_TAB_COMMENTS to unasync;
GRANT SELECT ON DBA_TAB_COLUMNS to unasync;
GRANT SELECT ON DBA_CONSTRAINTS to unasync;
GRANT SELECT ON DBA_CONS_COLUMNS to unasync;
GRANT SELECT ON DBA_PART_KEY_COLUMNS to unasync;
GRANT SELECT ON DBA_OBJECTS to unasync;
GRANT SELECT ON DBA_CONSTRAINTS to unasync;
GRANT SELECT ON DBA_IND_COLUMNS to unasync;
GRANT SELECT ON DBA_INDEXES to unasync;
GRANT SELECT ON DBA_VIEWS to unasync;
GRANT SELECT ON DBA_SOURCE to unasync;
GRANT SELECT ON DBA_PART_TABLES to unasync;
GRANT SELECT ON DBA_TAB_PARTITIONS to unasync;
GRANT SELECT ON USER_IND_SUBPARTITIONS to unasync;
GRANT SELECT ON V$ARCHIVED_LOG to unasync;
GRANT SELECT ON V$LOGMNR_CONTENTS TO unasync;
GRANT EXECUTE ON DBMS_LOGMNR TO unasync;
GRANT SELECT ON SYS.USER_MVIEWS TO unasync;
GRANT SELECT ON dba_col_comments to unasync;
CREATE SCHEMA TEST AUTHORIZATION SYSDBA;
CREATE TABLE "TEST"."TEST_KEY"
(
"ID" BIGINT NOT NULL,
"NAME" VARCHAR(100 CHAR),
"SEX" INTEGER,
PRIMARY KEY("ID")
);
CREATE TABLE "TEST"."TEST_NOKEY"
(
"ID" BIGINT NOT NULL,
"NAME" VARCHAR(100 CHAR),
"SEX" INTEGER
);
CREATE TABLE "TEST"."TEST_T1"
(
"ID" BIGINT NOT NULL,
"NAME" VARCHAR(100 CHAR),
"AGE" INTEGER
);
|
