Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with creating USER

677878Apr 28 2009 — edited Apr 28 2009
Hi 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
This post has been answered by OrionNet on Apr 28 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2009
Added on Apr 28 2009
16 comments
1,504 views