Accessing an Existing Schema via an External Authentication USER

Hi all,

Here is the situation: I have a Schema called ABC which holds all the relevant Oracle Objects for my application (Tables, Views, Functions, Procs, Packages, Sequences, Triggers). Originally, we simply logged into Oracle under this Schema directly and had access to all these objects (i.e.; connect ABC/mypassword_at_MyHostString). Now, we are going to test External Authentication with Windows NT. So, I created an External User (EXTUSER). In order to access the objects within the ABC Schema, I would now need to change all my application references to ABC.OBJECT_NAME from simply OBJECT_NAME and that is not an option.

My solution is to create Public Synonyms of the ABC Objects which would allow access to the ABC Schema objects through the synonyms. Therefore, when External Auth is used, my existing queries will reference the ABC schema through synonyms, basically mimicking the previous behaviour.

My question is should I set up a role and grant the ABC object privileges to that role, then grant the role to the EXTUSER? Is that necessary or desireable for security reasons?

Thanks. Received on Fri Jul 20 2001 - 12:24:28 CDT