Thanks a bunch. It is crystal clear now. [EMAIL PROTECTED] wrote: Remember that each database can have multiple schemas; a schema is really just a set of tables (and indexes, triggers, etc) that belong to a user. But if you've got user A who owns schema B in database XYZ, and your application needs access to the tables in schema B, then you can use user A's userid and password in CF admin for that datasource. You can also, if you like, create another user C and give that user whatever rights are needed to the tables (indexes, etc) in schema A. clear as mud, eh? -----Original Message----- From: Julia Phu [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 6:09 PM To: CF-Talk Subject: Re: [RE: [Re: Native Drivers - Oracle80]] Thank you so much for your assistance. I finally make it work. One more question if I can. If I create a user A who owns the schema of XYZ database with a password. Should I put user A for CF Login? Please advise. Salute, Julia Phu [EMAIL PROTECTED] wrote: First make sure that you can connect to the database using an Oracle tool like SQLPlus from the console of the CF server. Oracle has its own set of userids and passwords, so you'll have to create (or know) an oracle userid and password. And the "service name" is what you will put in the "host string" spot in CF Admin. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
