Re: Two Oracle admin questions.

Well...pardon me whilst I spit out those feathers. Though the OEM Security Manager doesn't show it being a system privilege in the RESOURCE role, it certainly does grant it. And, here's what the 7.3.4 doc says:

Note: If you grant or revoke the RESOURCE or DBA role to or from a user, Oracle7 implicitly grants or revokes the UNLIMITED TABLESPACE system privilege to or from the user.

--
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...)


><alan_psb_at_my-deja.com> schreef in berichtnieuws

>8frte7$g6v$1_at_nnrp1.deja.com...

>>

>>

>>

>>

>> But I remembeer that according to Oracle8i DBA Handbook (by Kevin Loney,

>> Marlene Theriault), they said the RESOURCE role can override the quota

>> value with the tablespaces. So they suggest the RESOURCE role should be

>> granted to users in development environment only.

>>

>> Alan

>>

>>

>> In article <j0eU4.1$A5.32_at_dit4.state.va.us>,

>>   "Alan Moorman" <alm2_at_XYZemail1.dss.state.va.us> wrote:

>> > In v7.3.4 and 8.0.5, RESOURCE role does not give you UNLIMITED

 TABLESPACE


>> > system privilege.

>> >