Database Administration (MOSC)

MOSC Banner

ORA-01045: user b lacks CREATE SESSION privilege; logon denied

edited Apr 16, 2013 1:18AM in Database Administration (MOSC) 6 commentsAnswered ✓
Hello All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center