Re: users in a group

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.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)