Re: Newbie question again!

Hartono Nugroho wrote:
>
> Hi all,
>
> I am university student studying on Oracle 8i and need confirmation on few
> things.
>
> I manage to make Oracle 8i use Win2000 beta server user authentication (I
> manage to connect to database without supplying password or connect as
> internal without password, etc). I think there is a problem with W2K
> professional that prevent it to work. Maybe it is W2K bug that Oracle only
> work in domain (client/server) and not on workgroup (peer to peer).
>
> OK, now for my questions:
>
> 1. Why I am not able to log in to SQL+ using my NT user name and password? I
> am under impression that if I put my NT user name/password with ORA_DBA
> roles then I can connect to a database (work OK for me) and connect to SQL+.
>
> 2. How do I share my tables with other users? Being unable to connect to
> SQL+ using my NT user name/password, I connected with Internal user name and
> then created a user <Ari> using USERS and TEMP tablespace as default and
> temporary tablespace. I also created another user <Hanugro> with the same
> USERS and TEMP tablespace. I then created three tables with <Ari> account
> and I could not see the table that I created earlier when I connected with
> the other account <Hanugro>. I understand that <Ari> has an ownership for
> the tables but how do I share a table with other user?
>
> Thanks very much for all of your help!
> Hartono

connect to <Hanugro>
type the command:

grant select on <table_name> to Ari;

Then <Ari> can select the table.

River
wychan_at_vol.net Received on Mon Aug 09 1999 - 09:49:30 CDT