Re: Two Oracle admin questions.

From: Alan Moorman <alm2_at_XYZemail1.dss.state.va.us>
Date: 2000/05/16
Message-ID: <j0eU4.1$A5.32@dit4.state.va.us>#1/1

In v7.3.4 and 8.0.5, RESOURCE role does not give you UNLIMITED TABLESPACE system privilege.

Alan Moorman
Oracle DBA
Oracle ERP DBA (as in "I can run adpatch") Unisys DMS DBA (yes, "antiquated" mainframe stuff that still kicks butt!) MS SQL Server DBA (don't ask...)

>In article <8frnjm$910$1_at_nnrp1.deja.com>,
> alan_psb_at_yahoo.com wrote:
>> Hello all,
>>
>> I have two questions: (Oracle 8.0.5 on Solaris)
>>
>> 1) I got error message when I created a table:
>>
>> ORA-01950: no privileges on tablespaces 'USERS';
>>
>> However, when I type "select * from user_role_privs", I see that I
>> have the RESOURCE and CONNECT role.
Received on Tue May 16 2000 - 00:00:00 CDT