Maybe someone has customized the RESOURCE role on version 11 by granting
the unlimited tablespace privilege? I've seen that sort of thing quite a
few times. Oracle has removed that privilege in version 9i, but the
older DBA personnel, with experience on the previous version, sometimes
overrides that change and grants all the privileges from the previous
versions. I don't like that sort of thing, I usually create a developer
role and never grant unlimited tablespace to it.
On 2/21/19 6:12 AM, John Dunn wrote:
--
I am using Oracle 12 for the first time.
I am creating my user, tables and inserting data the same way as I did for Oracle 11
But in Oracle12 (on windows) I get the above error.
I presume doing
ALTER USER myuser quota unlimited on USERS;
Will solve the issue, but I didn’t need to do that in Oracle 11
What has changed?
*John Dunn*
Senior Solutions Engineer
Sefas Innovation Limited.
Tel: + 44 (0) 117 910 0529
www.sefas.com <http://www.sefas.com/>
Advanced notice of holidays : March 7th 2019
My normal working days are Monday to Thursday