ORA-01045: user b lacks CREATE SESSION privilege; logon denied
i'm unable to connect throught Proxy user not sure where i went worng.
Data base : standared edtion.
verions : 11.2.0.3
below is the seps follwed by me:
create user a identified by a;
grant create session,resource,connect,create procedure to a;
create role test;
grant connect,resource,select any table,select any dictionary to test1;
grant select on V_$SESSION to test1;
alter user b grant connect through a with role test1;
conn a/a
resut is connected
conn b/b
result is connected
SQL> conn a[b]/a
ERROR:
ORA-01045: user b lacks CREATE SESSION privilege; logon denied