Newbie:Including other users in my own schema

From: Cyril Elkaim <celkaim_at_microform.fr>
Date: Wed, 19 May 1999 12:08:29 +0200
Message-ID: <37428D9D.64B9FEDE@microform.fr>

        Hi,

        Is it possible to intern other users in my own schema. That is, for the other users, assuming I grant them rights on my tables, to select, etc... without prefixing the name of my tables with my schema?

	creator:
		create table test (...)
		grant all on test to other
	other:
		select * from test
	and not:
		select * from creator.test

	The reason is that I must modify many, many queries in my application

and I really prefer to avoid that :-)

	Thanks
	Cyril Elkaim

Received on Wed May 19 1999 - 05:08:29 CDT