Re: grant resource

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Oct 1999 12:34:19 GMT
Message-ID: <380db5db.1756870@news.demon.nl>

On Wed, 20 Oct 1999 13:37:36 +0200, "Ivan Bajon" <iba_at_no_spam_at_post1.tele.dk> wrote:

>When I grant resource to a user (both 7.3.4 and 8.0.5) the Oracle
>automatically grants that user unlimited tablespace. Why?
>
>Tomas? Sybrand? Jonathan? Anyone?
>
>Thanks in advance,
>Ivan Bajon, OCP - guess I got lucky :o)
>
>

Resource is a role, for backwards compatibility with Oracle 6. Officially it's obsolete, but everyone (including Oracle) still uses it. As resource is a role NOT a privilege, several privileges have been granted to it, including unlimited tablespace privilege. Note: the same applies to CONNECT and DBA. Anyone with CONNECT automatically also has CREATE TABLE privilege. For end-users/operators you do not necessarily want that, and create session privilege should be sufficient.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Oct 20 1999 - 07:34:19 CDT