I am trying to setup a library, or libraries, that will allow me to access multiple schemas within the same library. Even if each library has to be its own schema, then I would still like to be asked for a logon just once. I would also like to share the same connection, so I do not exceed the limit on simultaneous connections. Are any of these goals possible?
I do not want to keep any usernames or passwords in the program, so I am expecting to use the dbprompt= option. I would like it to use the same username and password (and path) for all the subsequent libraries that may be created. Right now it still asks for a username and password each time the library is accessed the first time. These libraries are all the same, except a different schema is referenced.
I have tried the connection=global option to share the connection, but it still requires I log on 5 times (for 5 different schemas) and then exceeds the limit of 4 simultaneous user sessions. This limit is imposed by Oracle, not SAS, and is a requirement from our DBA.
I just want to signon 1 time and have access to the tables in 5 different schemas, just like I would with any SQL tool using Oracle.
Any ideas?
Mike