Re: users in a group

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 15 Feb 2004 09:29:19 -0800
Message-ID: <1076866113.372872@yasure>

Vu Pham wrote:

> "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

Additional resources can be found at:

http://www.psoug.org/reference/roles.html
http://www.psoug.org/reference/profiles.html
http://www.psoug.org/reference/procedures.html (AUTHID)
http://www.psoug.org/reference/dbms_wm.html (workspaces)

-- 
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)

Received on Sun Feb 15 2004 - 11:29:19 CST