Create Oracle User to only have ability to create tables, triggers, functions etc in one tablespace
Please help me in creating an Oracle user that can only create Oracle objects in a single tablespace that can only view tables that are granted them in another tablespace within the same SID.