Date: Mon, 31 Jan 2000 11:25:10 -0600 (CST)
To: "Hearley, Jennifer" 

> How can I make a table in one tablespace available to all users across
> multiple tablespaces without having to grant rights to each and every user.
> 
> 
> 
> 
> Jennifer M Hearley
> Lead Database Developer
> E-Commerce
> Newark Electronics
> jhearley@newark.com
> 773-907-5926
> 
You can GRANT the privilege to PUBLIC. "PUBLIC" is an Oracle construct
that allows just what you want - all users get that privilege. You can
also make PUBLIC synonyms.

An example syntax is:

GRANT SELECT ON SCOTT.EMP TO PUBLIC;

All users could then select with:

SELECT * FROM SCOTT.EMP;

Note that the users still have to specify "SCOTT.". To avoid this:

CREATE PUBLIC SYNOYM EMP ON SCOTT.EMP;

Then the users can simply ask:

SELECT * FROM EMP;

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 345+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://www.arikaplan.com                          <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->


Back to Ari Kaplan's Home Page