Re: roles and privileges 101

nevermind.

resource implicitly grants unlimited tablespace to a user. you can't grant that privilege to a role:

SQL> GRANT UNLIMITED TABLESPACE TO "BASE"; GRANT UNLIMITED TABLESPACE TO "BASE"
*
ERROR at line 1:
ORA-01931: cannot grant UNLIMITED TABLESPACE to a role

10 more minutes of searching and no waste of bandwidth. oh well.

chris

On 2/8/06, Chris Stephens <cstephens16_at_gmail.com> wrote:
> Ok, can some point out the reason for the following:
>
> resource is granted to a role. role is granted to user. user
> schedules job (dbms_scheduler) to insert some data into a file. job
> errors with: ORA-01536: space quota exceeded for tablespace
>
> resource granted directly to a user and problem goes away.
>
> i know that execute on procedures/packages can't be done through roles
> but i roles to roles to users shouldn't be a problem correct?
>

--
http://www.freelists.org/webpage/oracle-l