Hi Chris,

>>Concerning the database: at least when using Oracle, a separate instance
>>does cost money, a second database user (aka namespace) is free...
>>
>>
> Ca you use the database profix option to add in a "instance1-",
> "instance2-" type prefix to each of the database tables ? Or is this
> what you were sugesting ?

Do you mean the db_namespace configuration option? Yes.

Oracle is a bit different on this matter than other databases.
Here all tables are owned by the user who created the tables. Only
the user himself can access the tables using their name. Other users
must prefix the owner's name and a '.' to the table name, e. g.

pkiscop1.ca_certificate

This mechanism works for other databases, too, and can be used to
separate the tables between OpenCA instances.

Martin



-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
OpenCA-Devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/openca-devel

Reply via email to