RE: Re: Oracle 12 : ORA-01950: no privileges on tablespace 'USERS'

That is amazing they finally got rid of that hardcoded sql for unlimited tablespace to resource 😊

[Joe_Testa_Color_LinkedIn-2]

Joseph Testa
Database Services Security

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Kim Berg Hansen Sent: Thursday, February 21, 2019 7:35 AM To: JDunn_at_sefas.com
Cc: oracle-l digest users <oracle-l_at_freelists.org> Subject: [EXTERNAL] Re: Oracle 12 : ORA-01950: no privileges on tablespace 'USERS'

Nationwide Information Security Warning: This is an external email. Do not click on links or open attachments unless you trust the sender.

Hi, John
I'm guessing your scripts have a GRANT RESOURCE role to the users? Before version 12 this would also grant them unlimited tablespace, which could be a bad thing. So in version 12 this was changed: https://docs.oracle.com/database/121/DBSEG/release_changes.htm#GUID-68A4EC3E-4167-4534-B04B-ADD68F4EDE6A Cheerio
/Kim

Regards

Kim Berg Hansen
Senior Consultant at Trivadis
Oracle ACE Director

http://www.kibeha.dk
kibeha_at_kibeha.dk<mailto:kibeha_at_kibeha.dk> _at_kibeha<http://twitter.com/kibeha>

On Thu, Feb 21, 2019 at 12:12 PM John Dunn <JDunn_at_sefas.com<mailto:JDunn_at_sefas.com>> 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

--
http://www.freelists.org/webpage/oracle-l






(image/jpeg attachment: image002.jpg)