https://community.hpe.com/t5/operating-system-hp-ux/regarding-schema-sharing/m-p/2849300#M825720 You have a few options for something like this. You can grant select/update/delete privileges against the tables to the users, (or select/update/delete any table system privileges). This will allow them to access the tables. You would need to create public synonyms for each table to allow them to access the tables from a "select * from <TABLE_NAME>". <BR /><BR />Also, you could code your application to use an "alter session set current_schema = <USERNAME>" which would force them use the schema listed under "username". Most likely, the first option would be the simplest and most error free. <BR /><BR />Hope this helps,<BR /><BR />Brian</USERNAME></TABLE_NAME> Thu, 21 Nov 2002 22:35:06 GMT Brian Crabtree 2002-11-21T22:35:06Z https://community.hpe.com/t5/operating-system-hp-ux/regarding-schema-sharing/m-p/2849299#M825719 Hi all,<BR /> I am using Oracle 9i on red hat linux 7.2<BR /><BR />I need to know a few info;<BR /><BR />I have three users(schemas). I just need all the users to use only one schema(1) for all three users. How do I share the schema1 with the other two? Tables created in schema1 should be reflected for the other two users. Thanks much for the help.<BR /><BR />Parthiban Thu, 21 Nov 2002 09:18:13 GMT https://community.hpe.com/t5/operating-system-hp-ux/regarding-schema-sharing/m-p/2849299#M825719 Parthiban Dhananjeyan 2002-11-21T09:18:13Z https://community.hpe.com/t5/operating-system-hp-ux/regarding-schema-sharing/m-p/2849300#M825720 You have a few options for something like this. You can grant select/update/delete privileges against the tables to the users, (or select/update/delete any table system privileges). This will allow them to access the tables. You would need to create public synonyms for each table to allow them to access the tables from a "select * from <TABLE_NAME>". <BR /><BR />Also, you could code your application to use an "alter session set current_schema = <USERNAME>" which would force them use the schema listed under "username". Most likely, the first option would be the simplest and most error free. <BR /><BR />Hope this helps,<BR /><BR />Brian</USERNAME></TABLE_NAME> Thu, 21 Nov 2002 22:35:06 GMT https://community.hpe.com/t5/operating-system-hp-ux/regarding-schema-sharing/m-p/2849300#M825720 Brian Crabtree 2002-11-21T22:35:06Z