Hi Everyone, I've been digging through the docs and not finding answers to my questions, which might be under my nose, but I'd appreciate help:
> An outside application (non-4D; "real world" stuff) - needs to pull data from our 4D Server (Win, v15.x) via an ODBC connection. I can see how to turn ODBC on, but it is not clear how the 4D password system works for authentication (how is the userid and password passed inside the SQL query from the outside system?) > I don't quite get the concept of 'Schemas' - it appears that I need to put the tables I will allow access via ODBC into a Schema, but it is not clear what I need to do with the other tables (that should not be accessible via ODBC). This is the source of confusion, from the 4D Design Ref (v15), talking abtout setting types of access to schemas: "More specifically, if you only assign Read Only type access to one group this will not have any effect since this group as well as all the others will continue to benefit from Read/Write access (assigned to <Everybody> by default). In order to set a Read Only type access, you also need to configure the Read/Write access." I"m not clear at all about why "this will not have any effect...") > Ideally I'd like to create a view and only allow the ODBC connection to query on the view. I'm not clear on how this works with the Schema idea. Anyone have some experience they are willing to share? I most appreciate it! Bob Miller Chomerics, a division of Parker Hannifin Corporation ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
