table access

[zapata]

I created a table called user_access
with user_name and password fields.
Next I created 5 users with the create user command.
When I try loggin to forms with my login info;
example zapata/egon@db00. I get connected but when I try loggin in with any of the 5 users I created, I always get
error object table or views do not exist.
Why is this?
How can I fix this problem?
thank you

 

[klegal]

In order to give other users access to an Oracle table or other object such as a sequence, package or view, you need to do the following:

1) Determine who owns the table:

select * from sys.dba_tables where table_name = 'your table name here';

2) login to SQLPlus or the tool you used to create the table as the owner of the table and enter the following commands:

create public synonym your_table_name for your_table_name;
grant connect, resource to public on your_table_name;

This allows users to access the table directly without the need to qualify the table name with the owner(eg. table_owner.your_table_name)

 

[zapata]

thanks klegal. that is exactly what I needed.
I had tried public synonym before but it did not work.
I don't know it did not work the first time I tried it.
but it worked now.
I did not use the grant connect, resource syntax because it would not have worked anyway.
You use that when a new user is created.
Thanks for your help.