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

From: "Testa, Joseph S" <TESTAJ3@xxxxxxxxxxxxxx>
To: "kibeha@xxxxxxxxx" <kibeha@xxxxxxxxx>, "JDunn@xxxxxxxxx" <JDunn@xxxxxxxxx>
Date: Thu, 21 Feb 2019 12:40:19 +0000

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

-------------------------------
Quit doing what is easy and do what is right.

[Joe_Testa_Color_LinkedIn-2]

Joseph Testa
Database Services Security

From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Kim Berg Hansen
Sent: Thursday, February 21, 2019 7:35 AM
To: JDunn@xxxxxxxxx
Cc: oracle-l digest users <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx<mailto:kibeha@xxxxxxxxx>
@kibeha<http://twitter.com/kibeha>

On Thu, Feb 21, 2019 at 12:12 PM John Dunn
<JDunn@xxxxxxxxx<mailto:JDunn@xxxxxxxxx>> 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

References:
- Oracle 12 : ORA-01950: no privileges on tablespace 'USERS'
  - From: John Dunn
- Re: Oracle 12 : ORA-01950: no privileges on tablespace 'USERS'
  - From: Kim Berg Hansen

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

Other related posts: