How to share a schema with other users?

I have created a number of tables/views using a DBA role user. What I want to do is the allow other less privleged users to share this schema's data. After I granted the select right to other users, I found that other users still have to access the tables with the schema name before the table name, like

select * from <schema name>.<table name>

Does anybody know if there's any way to simplify this troublesome naming scheme? Can I do anything to allow other less privileged users to access the tables by the table names only?

Any opinion is welcome! Received on Sat Jul 13 2002 - 12:18:18 CDT