Asad99 wrote:Please read the resource role description at http://psoug.org/reference/roles.html especially the part in red.
schema and user are same things. schema is database object and we know them as user.
step 1: create user
create user test identified by test account unlock;
step2: grant required role;
grant connect,resource to test;