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
Oracle does not support "groups" per se.
Go RTFM regarding ROLES.
Privs can be granted to ROLES.
ROLES can be assigned to users.
Received on Sat Feb 14 2004 - 13:25:18 CST
