Questions tagged [ora-01045]

im using oracle db v21c , after trying to create a role student with privs 'create session , create table , create view ' a granted that role to a user 'user3' but when trying to connect with that user i got ora-01045. i checked that privs granted…

I tried to grant CONNECT to a user through a role: CREATE ROLE my_role IDENTIFIED BY "passwd"; GRANT CONNECT TO my_role; CREATE USER my_user IDENTIFIED BY "passwd"; GRANT my_role TO my_user; When I try this in 10g it works fine, while in 11g login…

I created a new user - CK - with Toad on 10g XE. An error popup when I use CK to login: ORA-01045: user CK lack create session privilege. What privilege do I should give to CK? BTW: but I can use SqlPlus to login