Re: Access schema using a different user
From: Patrick Jolliffe <jolliffe_at_gmail.com>
Date: Fri, 12 Feb 2016 20:48:23 -0800 (PST)
Message-ID: <7647A825AE7A448D.91BF2958-A922-48CC-B484-9E4DB3EBDD56_at_mail.outlook.com>
Another option is proxy authentication. Difference in that case is user has complete access to target schema, just uses own name and password to authenticate. https://oracle-base.com/articles/misc/proxy-users-and-connect-through
From: John Dunn <jdunn_at_sefas.com>
Sent: Thursday, February 11, 2016 19:08
Subject: Access schema using a different user To: oracle-l digest users <oracle-l_at_freelists.org>
Date: Fri, 12 Feb 2016 20:48:23 -0800 (PST)
Message-ID: <7647A825AE7A448D.91BF2958-A922-48CC-B484-9E4DB3EBDD56_at_mail.outlook.com>
Another option is proxy authentication. Difference in that case is user has complete access to target schema, just uses own name and password to authenticate. https://oracle-base.com/articles/misc/proxy-users-and-connect-through
From: John Dunn <jdunn_at_sefas.com>
Sent: Thursday, February 11, 2016 19:08
Subject: Access schema using a different user To: oracle-l digest users <oracle-l_at_freelists.org>
I want to give a another database user to access to my schema
I know I can create a role that will grant rights/privileges to the new user to allow them to access the schema objects.
However the application will reference the database tables etc using the user that is used to connect and obviously the tables will not exist for that user.
Is the only way to resolve this using synonyms or is there something simpler?
Oracle version is 11.2
Any help appreciated.
John Dunn
Product Consultant
Sefas Innovation Limited.
Tel: + 44 (0) 117 910 0529
www.sefas.com
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Feb 13 2016 - 05:48:23 CET