Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> roles and privileges 101

roles and privileges 101

From: Chris Stephens <cstephens16_at_gmail.com>
Date: Wed, 8 Feb 2006 09:16:25 -0500
Message-ID: <d95e86070602080616g5701f21bof225a96ccf8568b0@mail.gmail.com>


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
Received on Wed Feb 08 2006 - 08:16:25 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US