Problem with creating USER
677878Apr 28 2009 — edited Apr 28 2009Hi Friends
I am trying to create new database User (schema( And after that i would associate this schema with Oracle APEX workspace)).But i am not able to create this User its show me error "ORA-00911: invalid character" when i m try to execute code for the user.so can anyone plz help me for this...
ALTER USER JD
IDENTIFIED BY VALUES 'abc'
DEFAULT TABLESPACE FLOW_1
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 2 Roles for JD
GRANT DEV_USER TO JD;
GRANT CONNECT TO JD;
ALTER USER JD DEFAULT ROLE ALL;
-- 14 System Privileges for JD
GRANT CREATE TYPE TO JD;
GRANT CREATE MATERIALIZED VIEW TO JD;
GRANT CREATE VIEW TO JD;
GRANT CREATE CLUSTER TO JD;
GRANT CREATE TABLE TO JD;
GRANT CREATE SEQUENCE TO JD;
GRANT CREATE ANY CONTEXT TO JD;
GRANT CREATE TRIGGER TO JD;
GRANT CREATE SYNONYM TO JD;
GRANT CREATE OPERATOR TO JD;
GRANT CREATE JOB TO JD;
GRANT CREATE DIMENSION TO JD;
GRANT CREATE INDEXTYPE TO JD;
GRANT CREATE PROCEDURE TO JD;
-- 2 Tablespace Quotas for JD
ALTER USER JD QUOTA 50M ON SYSTEM;
ALTER USER JD QUOTA UNLIMITED ON FLOW_1;
-- 2 Object Privileges for JD
GRANT EXECUTE ON CTXSYS.CTX_DDL TO JD;
GRANT EXECUTE ON CTXSYS.CTX_DOC TO JD;
thanks
rommy