If you create as user by
Create user test …
Then the user is created as TEST
So first verify the case of your username
‘user‘ is a function that returns the name of the user who is logged in.
You can verify that your lowercase username is wrong by executing
This will return no rows, too.
And this will show the desired result
You can also query the view user_sys_privs to see the privileges of the user logged in
Her you avoid typing your username and you do not need privileges on the dba_sys_privs view.
If you want to create a user with a name in lowercase letters you have to use double quotes
Create user “test“ …