on 2011 Apr 25 3:42 AM
I'm connecting to an ASA 9 DB on Windows from a Rails app on a Mac. I can connect fine and execute SQL queries. The problem is that most of the tables are owned by a different user than my app is using, so I need ActiveRecord to generate its queries using fully qualified table names (ie. "select "table".* from "owner.table"). Is this possible with ActiveRecord 3.0.5?
Assuming that the error you are seeing is "Table 'xxx' not found", you can define the owner of the table as a group and grant membership to that group to the users that will need access to the table. By doing this, you can avoid the need to qualify the table with its owner in statements that reference the table. See: http://dcx.sybase.com/index.html#1201/en/dbadmin/udns.html
I have no experience with ActiveRecord.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
11 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.