How can I give access of my schema to other users in Oracle?

As far as I know you have to grant access one object at a time.

This can of course be done using a procedure like this

PROCEDURE GRANT_SELECT_ON_TABLES
    USERID IN varchar2 
IS
BEGIN
    FOR TABLES IN (
        SELECT  TABLE_NAME
        FROM    ALL_TABLES
        WHERE   OWNER = USER)
    LOOP
       EXECUTE IMMEDIATE 'GRANT SELECT ON '|| TABLES.TABLE_NAME ||' TO USERID;
    END LOOP;
END;

You have to run it while logged in as CCMS_ADMIN and it will take the user you want to grant select access to as a parameter.

Disclaimer: I haven't tested it as such and I don't have access to a server at the moment.