CONNECT TO cogsam83;

CREATE SCHEMA     GOSL;
COMMENT ON SCHEMA GOSL IS 'GO Sales';

CREATE SCHEMA     GOSLDW;
COMMENT ON SCHEMA GOSLDW IS 'GO Sales Data Warehouse';

CREATE SCHEMA     GOHR;
COMMENT ON SCHEMA GOHR IS 'GO Sales Human Resources';

CREATE SCHEMA     GORT;
COMMENT ON SCHEMA GORT IS 'GO Retailers';

CREATE SCHEMA     GOMR;
COMMENT ON SCHEMA GOMR IS 'GO Multilingual Retailers';

-- optional target schema for Data Manager
CREATE SCHEMA     GODMT;
 COMMENT ON SCHEMA GODMT IS 'GO Data Manager Target';

-- give the 'cognos' user dba privileges to administer the database and to populate it using DBMOVE
GRANT  DBADM
	ON DATABASE  
	TO USER cognos;

CONNECT RESET;