User test lacks create session privilege logon denied solution: create a user test in the oracle database. If the permissions assigned to test are insufficient, the user test lacks create session privilege logon denied will be prompted when you log on with test. The reason is that test requires at least the session right, otherwise the connection will fail, you should have the right to perform other operations. Specific solution: Use the dba of oracle to log on to www.2cto.com. At least you must have the ability to grant permissions to other users. Then run 'Grant connect to test; 'and 'Grant resource to test;' without quotation marks when executing SQL. Sometimes the above information is prompted after such an operation, and then execute 'Grant create session to test; 'the above SQL results all prompt that the authorization is successful, and then try to log on, it will be OK.