set echo on

--conn system/oracle

--drop user rss cascade
--/

--drop tablespace rss
--/
--commit
--/
create user rss identified by rss
-- default tablespace users
/

create tablespace rss datafile 'rss.f' size 100m reuse 
segment space management auto;

alter user rss default tablespace rss;

grant create session to rss
/
grant create table to rss
/
grant create view to rss
/
grant unlimited tablespace to rss
/
grant xdbadmin to rss
/
grant create type to rss
/
grant create sequence to rss
/
grant ctxapp to rss
/
grant resource to rss
/
grant select_catalog_role to rss
/
