If you use Oracle for
your SAS Decision Manager 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 SASHome\SASDecisionManagerCommonDataServer\3.2\Config\Deployment\dbscript\Oracle\optional.
Use your preferred Oracle tool to run these scripts. One of these
scripts, brm_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_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_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_create_synonym.sql using your preferred Oracle tool. This script
does not require substitution variables.
-
Run brm_grant_priv_synonym.sql
using your preferred Oracle tool.