Re: newbie question configuring 8i personal

There is a way, but before of that you should be studying a little the Oracle documentation if you plan to use it(Oracle) in the near future. Otherwise you are just loosing your time.

--
Cheers,
Valentin

[to reply remove "~3114" from the email address]
"Ed-D" <Ed-D_at_despammed.com> wrote in message
news:HGe19.5067$op5.3908_at_nwrddc03.gnilink.net...


> X-No-Archive: yes

>

> "Valentin Minzatu" <~3114vminzatu_at_rogers.com> wrote in message

> news:z1W09.218605$WJf1.156833_at_news01.bloor.is.net.cable.rogers.com...

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


> >

>

> awesome thanks....now if only there was a way to select all tables created

> by all users and the access granted on each?  there must be a way to do

> this, I just can't figure out the syntax.....

>

> > --

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

> > >

> > >

> >

> >

>

>