Signalled during ORA-1031
Error message: ORA-1031 signalled during: create tablespace name datafile '+ data' size 10 M autoextend on next 5 M maxsize unlimited...
Problem description
In the newly deployed Oracle environment, a designer user needs to call the stored procedure to create a tablespace at every day. This user already has the connect, resource, and dba permissions.
If the tablespace is not created the next day, find alert _ <sid>. log to see the ORA-1031 signalled during: create tablespace name datafile '+ data' size 10 M autoextend on next 5 M maxsize 100M... such prompt information.
It is no problem to copy the tablespace creation statement to the designer user for execution. Then, when you run the job manually, the same message is displayed, and the tablespace is not created successfully. When the stored procedure is called separately, if you forget to set the set serveroutput option, the execution is successful and no prompt is displayed. Finally set serveroutput on to discover a prompt like ora-01031: insufficient privileges. Grant the user the following permissions:
Grant create tablespace to designer;
No error is reported after testing.
However, the question is that the designer user has the DBA permission. the DBA permission also includes the create tablespace permission, and the job and stored procedure are also created under the designer, why do I have to assign the tablespace creation permission to designer separately to create the tablespace successfully?