Re: grant resource

Sybrand is correct. As to why they haven't mapped the roles correctly to equivalent privileges, only the developer who did this could tell you. Basic advice is to create your own roles that grant the right privileges, then use those.

Pete

Sybrand Bakker wrote:

> 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 - 13:54:45 CDT