Multiple Oracle Users in Bentley Map

Hi,

What would be the best work flow to allow for multiple Oracle Users when using a Bentley Map schema? For security reasons we would like each user to have a separate login when connecting to Oracle. 

Regards,

Krister

Parents Reply
  • Krister,

    You will first need to grant each user the required privileges for the table(s) and sequence(s) (if INSERT is required) object(s) from your master schema. Then view(s) are created with disabled primary key constraints that are named the same as the master table(s). Finally you would need to add the required metadata into the USER_SDO_GEOM_METADATA view, using the values from the same master table entries as seen from the ALL_SDO_GEOM_METADATA view.

    For example, a SQL script similar to the following could be used.

    Regards,

    Jeff Bielefeld [Bentley]



Children