If you use Oracle for
your SAS Decision Manager Common Data Server database
and you do not want to use the default schema, you can run two SQL
scripts to create synonyms for the database tables. These scripts
are in SAS_HOME\SASDecisionManagerCommonMidTierforDecisionManager\2.2\Config\Deployment\dbscript\Oracle\optional.
Use your preferred Oracle tool to run these scripts. One of these
scripts, brm_oracle_grant_priv_synonym.sql,
uses substitution variables. If your Oracle tool does not support
substitution variables, then you need to manually replace the variable
with its value, as described in Step 2.
To run these scripts:
-
In the script named
brm_oracle_grant_priv_synonym.sql,
find the following line:
def usernm='YOUR_USER_NAME';
Replace
YOUR_USER_NAME with
the user ID that you are using to access the SAS Decision Manager
database.
If your Oracle tool
supports substitution variables, skip to Step 3. If not, continue
with Step 2.
-
If your Oracle tool
does not support substitution variables, in the script named
brm_oracle_grant_priv_synonym.sql,
replace all occurrences of
&usernm with
the user ID that you are using to access the database.
-
Run the script named
brm_oracle_create_synonym.sql using
your preferred Oracle tool. This script does not require substitution
variables.
-
Run
brm_oracle_grant_priv_synonym.sql using
your preferred Oracle tool.