Re: newbie question configuring 8i personal

Assuming that scott is the owner of EMP and demo is the owner of EMPPLOYEE, here is the simplest way to do what you want:

1. connect scott/tiger
2. GRANT SELECT ON emp TO [your_user];
3. connect demo/[demo_passwd]
4. GRANT SELECT ON employee TO [your_user];
5. connect [your_user]/[passwd]
6. SELECT * FROM scott.emp; -- returns all rows in scott's emp table
7. SELECT * FROM demo.employee; -- returns all rows in demo's employee table

--
Cheers,
Valentin

[to reply remove "~3114" from the email address]
"Ed-D" <Ed-D_at_despammed.com> wrote in message
news:TWL09.12694$9U4.8467_at_nwrddc01.gnilink.net...


> For whatever reason I can't grant table access to other users.  Only the


> owner of the table gets access.  I'm pretty sure I'm configuring the

 tables


> correctly, I'm following the direct instructions from the "Help" file.


>

> I've also tried creating a new user with access to everything but that

> doesn't seem to work either.

>

> For example, I want a user to be able to access both "EMP" and "EMPLOYEE".

> "Scott" is the owner of "EMPLOYEE", "Demo" the owner of "EMP" (Or maybe

 its


> the other way around, I can't remember).  I need a user who can access


 both


> tables (and all other ones) within the same SQL session.


>

> Can anybody help?

>

>