Hi all: 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 ...
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 is rejected: ORA-01045:user MY_USER lacks CREATE SESSION privilege; logon denied Gran...