Re: roles and privileges 101
- From: Thomas Fox <belvdr@xxxxxxxxx>
- To: cstephens16@xxxxxxxxx, oracle list <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 8 Feb 2006 06:58:50 -0800 (PST)
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@xxxxxxxxx> 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?
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
