Re: roles and privileges 101

From: Thomas Fox <belvdr_at_yahoo.com>
Date: Wed, 8 Feb 2006 06:58:50 -0800 (PST)
Message-ID: <20060208145850.99753.qmail@web32407.mail.mud.yahoo.com>

Make sure that the role is set as a default for that user:

ALTER USER DEFAULT ROLE <role1>,<role2>,<roleN>;

or
ALTER USER DEFAULT ROLE ALL; if you want the user to have all of the roles assigned to be inherited at the time of login.

If it isn't set as a default role, then you would have to do:

SET ROLE <role_name>;

If you have a password set for the role:

SET ROLE <role_name> IDENTIFIED BY <password>;

• 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
>
>
>

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Wed Feb 08 2006 - 08:58:50 CST