Re: How can users be arranged into a group?

ronald_at_mix004.nwg.dec.com (Ronald van der Burg) wrote:

>Hi,
 

>Thanks for reading. I created a number of user accounts on an Oracle db, each
>with default tablespace 'USERS'. If one user creates a table, how can it be
>made visible to other users?
 

>Unix makes it possible to arrange users into a group. All users belonging to a
>group can share files easely. Can this be done in a similar way with Oracle?
>If so, how?

The owner (creater) of the table must grant privileges to the other users, or to 'public', for his tables that he wants them to be able to see.

ex.

GRANT SELECT ON mytable TO JOE;

Oracle also has something called roles which allow you to work with whole groups of users. You can grant object privileges to a role, and then grant the role to the appropriate users.

ex.

CREATE ROLE payroll;
GRANT INSERT,UPDATE,SELECT ON mytable TO payroll; GRANT payroll TO jane,joe;

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!