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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
