search for: current_schema

Displaying 2 results from an estimated 2 matches for "current_schema".

2006 Jun 30
0
Setting default schema with Oracle
I wish to avoid putting the schema name inside each model class. set_table_name "schemaName.tableName" In Oracle one does this with the following statement ... alter session set current_schema = ApplicationDatabaseAccount; How do I do this for the connection Rails makes for me? How do I control the size of the connection pool? Thanks, Dennis Byrne -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/2...
2009 Dec 01
3
best practises for avoiding to write passwords in shell scripts (example sqlplus from Oracle)
Hi folks I have here a CentOS box where i need to setup cronjob (with session to remote Oracle instance). On the remote DB i have no access, expect limited user. How to avoid putting passwords in shell scripts? The solution doesn't need to be perfect, only better than plain text passwords in scripts. Mostly remote host only support password authentication (no certificates and so on).