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

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
_at_kibeha <http://twitter.com/kibeha>

On Thu, Feb 21, 2019 at 12:12 PM John Dunn <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
>
> Advanced notice of holidays : March 7th 2019
>
> My normal working days are Monday to Thursday
>
>
>
>
>

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