User cannot see tables created by another user

[adcworks]

Hi there, I am trying to setup a db with 2 user types.

appadmin
appuser

appadmin is used for creating stuff whilst
appuser just for queries and updates.

I created the users and I created 2 associated
roles. However I have not setup the appuser role yet.

i created a load of tables connected as
appadmin user into the app tablespace.

Both users have default tablespace app.

Why is it that i can only see these tables
connected as appadmin and not appuser??

Pointers appreciated.

[Sameer]

Originally posted by adcworks
Why is it that i can only see these tables
connected as appadmin and not appuser??

Privileges... Your appuser need privileges to access tables created by appadmin. Either grant privileges directly to appuser or grant through role.. and grant that role to appuser..

Sameer

[pando]

where are synonyms?

where are the grants on those tables to appuser?

[adcworks]

yes but which privileges do I need to create?

[adcworks]

connected in as appadmin i tried

grant all privileges on table1 to appuser_role;

grant appuser_role to appuser;

connecting as appuser still shows no table

[Sameer]

Originally posted by adcworks
connected in as appadmin i tried

grant all privileges on table1 to appuser_role;

grant appuser_role to appuser;

connecting as appuser still shows no table

what you mean "connecting as appuser still shows no table"

While quering table1 you must qualify that table

connect as appuser and then

select * from appadmin.table1

or else create private synonym for table1 to avoid qualification..

connect as appuser

create synonym table1 for appadmin.table1;

then only you will able to select without qualifing

Sameer

[pando]

I thought I mentioned synonyms as well

[adcworks]

that's quite a long winded way of exposing tables created by ne user to other users is it not? Is this the only way

ps: yes it worked. thanks