Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: users in a group
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1076788707.866644_at_yasure...
> Vu Pham wrote:
> > If I understand correctly , under Oracle , then each project will be
> > logically orgzanized as a schema. Each schema is corresponding to a user
> > with same name. For other users to be able to access to this schema,
then
> > permissions need to be granted appropriately to them.
> >
> > Under Enterprise Manager, I see all users under the same level. Can I
group
> > users into group corresponding to each schema so that I don't need to
look
> > thru all users of different projects ( schemas ) ?
> >
> > I understand that there are users who access multiple schemas, but I am
> > still looking for a way I can know all users for a given project.
> >
> > Thanks,
> >
> > Vu
>
> In addition to ROLES as suggested by A.C.D. also look up the following
>
> 1. Profiles
> 2. Consumer Groups
> 3. Work Groups
> 4. Invoker Rights (AUTHID)
>
> A.C.D. is correct but there are additional tools for managing related
> resources.
>
Thanks, Ana and Daniel. Last night I read and practised the ROLE and PROFILE part, and now I can undertsand a little bit.
Vu Received on Sun Feb 15 2004 - 06:19:56 CST
![]() |
![]() |