Thread: Feature request for setting the role with the URL connection string
Hello! I think it would be a nice feature, to be able to set the role of database user with the URL of the connection string, as PostgreSQL 8.1 has the concept of roles now. The jdbc-driver of Firebird has the connection parameter 'sql_role_name' for this feature. This would allow without code changes of the application to exchange a Firebird-database with a PostgreSQL-database. Just an idea. (Viewing on the source code, I did not find any starting point to do it myself.) Regards, Roland. -- Roland Walter mailto: rwa (at) mosaic-ag (dot) com MOSAIC SOFTWARE AG phone: +49 (0) 22 25 / 88 2-41 1 Am Pannacker 3 fax: +49 (0) 22 25 / 88 2-20 1 D-53340 Meckenheim http://www.mosaic-ag.com Die in dieser E-Mail enthaltenen Nachrichten und Anhaenge sind ausschliesslich fuer den bezeichneten Adressaten bestimmt. Sie koennen rechtlich geschuetzte, vertrauliche Informationen enthalten. Falls Sie nicht der bezeichnete Empfaenger oder zum Empfang dieser E-Mail nicht berechtigt sind, ist die Verwendung, Vervielfaeltigung oder Weitergabe von Nachrichten und Anhaengen untersagt. Falls Sie diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte unverzueglich den Absender und vernichten Sie die E-Mail. This e-mail message and any attachment are intended exclusively for the named addressee. They may contain confidential information which may also be protected by professional secrecy. Unless you are the named addressee (or authorised to receive for the addressee) you may not copy or use this message or any attachment or disclose the contents to anyone else. If this e-mail was sent to you by mistake please notify the sender immediately and delete this e-mail.
Roland Walter wrote: > (Viewing on the source code, I did not find any starting point to do > it myself.) Probably do it in the AbstractJdbc2Connection constructor -- run an appropriate query after the underlying connection is established. This almost belongs in the application, though.. isn't the role syntax standardized? -O
Oliver Jowett <oliver@opencloud.com> writes: > Roland Walter wrote: > >> (Viewing on the source code, I did not find any starting point to do >> it myself.) > > Probably do it in the AbstractJdbc2Connection constructor -- run an > appropriate query after the underlying connection is established. > > This almost belongs in the application, though.. isn't the role syntax > standardized? Setting the role is a problem, if you must use an abstraction layer for accesses to the database that you are not allowed or able to change. The abstraction layer handles all database specific features. Setting the role with the URL would mimic the behaviour of DB2 to be able to set the 'search_path' to the database tables automatically with the connection parameter 'currentSchema'. Regards, Roland. -- Roland Walter mailto: rwa (at) mosaic-ag (dot) com MOSAIC SOFTWARE AG phone: +49 (0) 22 25 / 88 2-41 1 Am Pannacker 3 fax: +49 (0) 22 25 / 88 2-20 1 D-53340 Meckenheim http://www.mosaic-ag.com Die in dieser E-Mail enthaltenen Nachrichten und Anhaenge sind ausschliesslich fuer den bezeichneten Adressaten bestimmt. Sie koennen rechtlich geschuetzte, vertrauliche Informationen enthalten. Falls Sie nicht der bezeichnete Empfaenger oder zum Empfang dieser E-Mail nicht berechtigt sind, ist die Verwendung, Vervielfaeltigung oder Weitergabe von Nachrichten und Anhaengen untersagt. Falls Sie diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte unverzueglich den Absender und vernichten Sie die E-Mail. This e-mail message and any attachment are intended exclusively for the named addressee. They may contain confidential information which may also be protected by professional secrecy. Unless you are the named addressee (or authorised to receive for the addressee) you may not copy or use this message or any attachment or disclose the contents to anyone else. If this e-mail was sent to you by mistake please notify the sender immediately and delete this e-mail.