RE: RESOURCE role

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Mon, 30 Apr 2001 20:07:45 -0700
Message-ID: <F001.002F6024.20010430195520@fatcity.com>

> -----Original Message-----
> From: Jared Still [mailto:jkstill_at_cybcon.com]
> Granting RESOURCE to a user results in UNLIMITED TABLESPACE
> being granted directly to the user account.

Jared is correct. I sent another e-mail adding that but it didn't go through (mail error). Sorry for the bad information. By the way, my previous e-mail contained an additional question that I will reproduce below.

---

Sorry, in my previous answer I forgot to say that when you grant role RESOURCE to a user, the user also gets assigned DIRECTLY the system privilege UNLIMITED TABLESPACE (see dba_sys_privs for that username). I would guess that this happens because of some code in a system package like dbms_standard, but I'm not sure. Does anyone know how UNLIMITED TABLESPACE gets granted to the user along with the role RESOURCE ?

---

Received on Mon Apr 30 2001 - 22:07:45 CDT