I want a database to accept both MTS and Dedicated Server connections. Users that I want to use MTS will go through one tnsnames.ora alias and those who use Dedicated Servers will use a different alias. For example, I want some users to:

sqlplus user1/[email protected]

and other users to:

sqlplus user1/[email protected]

Has anybody ever done this before? Any suggestions?