User Guide

SAP AG November 2002
4. You use the ALTER_USER- [See SAP DB Library] and ALTER_USERGROUP-statement
[See SAP DB Library] to define which of the roles that were assigned to a user or user
group is to be used when a database session [Page 135] is opened.
5. During a database session, you can use the SET statement [See SAP DB Library] to
activate other roles assigned to the user or user group
If a role is activated during a session, the current user then has all the privileges that are
assigned to a role.
If a password has been assigned to a role, users assigned to that role can only activate it
by entering the password in the SET statement.
Result
That a role is available and the properties of that role are all registered in the catalog [Page
131] in the form of metadata. A user that creates a role becomes its owner.
The roles assigned to the user or user group as a result of the ALTER USER and ALTER-
USERGROUP statements are activated as soon as a database session is opened.
Roles are not active during execution of data definition commands [See SAP DB
Library].
See also:
Reference Manual: SAP DB 7.4, Section Role Name [See SAP DB Library]
User Data as Options
User data and, in some cases, other data can be entered as options when calling the SAP DB
tools, the C/C++ Precompiler, or the application programs.
Syntax
<dbmcli | loadercli | dbmgui | sqlsto | cpc <file_name>> [<options>]
...
<options>
SAP DB Component
DBMCLI DBMCLI options [Page 61]
SAP DB Loader Options (LOADERCLI) [Page 64]
DBMGUI DBMGUI options [Page 60]
SQL Studio SQL Studio options [Page 66]
C/C++ Precompiler/application programs C/C++ Precompiler options [Page 32]
If you enter all the required user data (in most cases, the options -u, -d, -n) and these
entries are complete and correct, you will be logged on to the desired SAP DB tool or the
C/C++ Precompiler.
For each tool, the user data required for logon to a database instance must be entered. For
DBMGUI and SQL Studio, options are not necessarily required, but this data can also be
entered in a logon screen. For other tools, there are required options [Page
34], which must
always be entered.
The SAP DB tool DBMCLI and the C/C++ Precompiler support the XUSER concept (User
Data Using XUSER [Page 34]).
User Manual: SAP DB 31