| From: BROKE::BITHER "Please reply to dbither@us.oracle.com" 21-MAY-1997 08:20:28.46
To: MEMORMAN
CC: BITHER
Subj: New STARS article
TITLE: %RDB-F-UNS-RCI Using Database Service with Distributed Option
PRODUCT: Distributed Option 7.*
RELATED
PRODUCTS: SQL/Services 7.*
OP/SYS: OpenVMS VAX, OpenVMS AXP
SOURCE: Oracle Worldwide Customer Support
PROBLEM:
Distributed Option v7.00
Rdb v7.0-01
SQL/Services v7.00
Attaching to a Distributed Option database using a database service with
authorization by connect user fails with:
[Oracle][ODBC][Rdb]%RDB-F-UNS-RCI, RCI call rdb_set_authorization
is not supported by DataBase Integrator (#-1)
What works:
Generic service authorization by either connect username or service
name - to an Rdb database.
Generic service authorization by either connect username or service
name - to a Distributed Option database.
Database service authorization by either connect username or
service name - to an Rdb database.
Database service authorization by service name only - to a Distributed
Option database.
What fails:
Database service authorization by connect username - to a Distributed
Option database.
SOLUTION:
This is a restriction. Use either a generic service where authorization is by
either service name or connect username, or use a database service where
authorization is by service name only to access a distributed option database
from SQL/Services.
\
\ CONTRIBUTORS:
\
\ Technical: Diane Bither
|