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???

Thanks