Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: direct grant vs. grant via role
michael pelzelmeyer wrote:
>
> hi folks,
> i'm searching for differences between direct grants vs. grants via
> roles. so far i've the following points:
> - perms. for objects for create views have to be direct
> - perms. for objects used in stored procs/funcs/triggs have to be
> direct
> - grant INDEX,REFERENCES,UNLIMITED TABLESPACE have to be direct
> - no grant WITH GRANT OPTION possible via roles
> are there any other limitations/pitfalls?
> tia
> michael
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Here's one I came across recently:
- grants to users running background jobs (dbms_job.submit) have to be
direct;
when the job starts running no roles are active.
Received on Fri May 28 1999 - 15:27:24 CDT