Re: Oracle 12 : ORA-01950: no privileges on tablespace 'USERS'
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 23 Feb 2019 21:39:52 -0500
Message-ID: <03444f78-5c50-5686-be83-de67930765d2_at_gmail.com>
Date: Sat, 23 Feb 2019 21:39:52 -0500
Message-ID: <03444f78-5c50-5686-be83-de67930765d2_at_gmail.com>
No. They got rid of it in version 10. Since version 10, the "RESOURCE" role was granted no privileges. 11G continued this nice tradition.
On 2/21/19 7:35 AM, Kim Berg Hansen wrote:
> 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.
Yes, I agree. Usually, it was a horrific disaster but it could be only a bad thing.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 -- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 24 2019 - 03:39:52 CET