Schema mapping for users
883119Aug 22 2011 — edited Aug 22 2011Hello,
I need to map a schema which was created for one user for many others.
Current situtuation:
Every user of the application has it's own login which will be used for db connection/auth.
The problem is when I simply gave them access to it they can only access it through:
+USER_SCHEMA.OBJECT/TRIGGER/etc. but our application assumes that it is currently in the schema so no "let me say" additional namespace is required.
Every user of the application has it's own login which will used for db connection.+
Is it possible to map the schema e.g. SCOTTs SCHEMA for let say MOON so as it would appear to be the own of MOON so that he don't need any qualifer SCROTT.TRIGGER2 or SCOTT.TABLE4?
Is this something I can achive with proxy users?
Thanks in advance.
Edited by: ioGLNX on 22.08.2011 04:24
Edited by: ioGLNX on 22.08.2011 04:27