create user u1 indentified by password;

grant connect to u1;

grant select on scott.emp to u1l

create role ro1 identified by oracle;

grant create view to ro1;

grant ro1 to u1;

create user u1 indentified by password;

grant connect to u1;

grant select on scott.emp to u1l

create role ro1 identified by oracle;

grant create view to ro1;

grant ro1 to u1;