I have an application and this application had certain role to let to application to create the new user. when I log in as the admin user and create the new user I got the error invalid tablespace and the tablespace is in the database.
if I log in as the user with DBA privileges and create a new user and I have no problems.
I was wondering what privilege do I miss or I need to grant to the application admin???
IF you revoke that 'ADMIN' role from user when he logs out from Application, For testing purpose, Try granting that 'ADMIN' role again from SQLPLUS.
What is your syntax(the one that is giving you problem) for creating user within the application. and What is the exact Oracle Error you get. These additional details would help someone over here to help you.