Replace <user name> and <initial password> with your values:
Refer to
step c (Create a password).
CREATE USER <user name> PASSWORD <initial password> ;
GRANT RDS_<DOMAIN>_PA_ADMIN TO <user name>;
GRANT RDS_<DOMAIN>_PA_BI_ADMIN TO <user name> WITH ADMIN OPTION;
GRANT RDS_<DOMAIN>_PA_ADMIN TO <user name> WITH ADMIN OPTION;
The output window of the SQL Editor notifies when the command is successfully run.
The initial password established for this data scientist user has a change password
requirement at first logon. Refer to section Establish Permanent password.
Verify the creation by opening a SQL Window using your data scientist account.
o
SAP_RDS_PA_<DOMAIN> schema is visible in catalog area of that user name
o
SAP_ERP_V4 schema is visible in catalog area of that user name for sales and
marketing, manufacturing related scenarios.
b) Creating a Business User Role
The Business User role is a consumer of information provided by the Data Scientist. For some
scenarios, the Business User has permission to create predictive analysis and construct
visualizations using SAP BusinessObjects Explorer.
Execute these steps to establish this type of account. Under the SYSTEM account, open
the SQL Editor by right-clicking on the
SYSTEM
account and selecting
SQL Console
.
Then copy the SQL instructions from below (the electronic version of this document) and
paste them directly into the SQL Editor.
Replace <business user name> and <initial password> with your values:
Refer to
step c (Create a password).
CREATE USER <
business
user name
> PASSWORD <
initial password
> ;
GRANT RDS_<DOMAIN>_PA_BI_ADMIN TO <
business
user name>
WITH ADMIN OPTION;
The output window of the SQL Editor notifies when the command is successfully run.
