User guide

When you use a Multi-process server a separate executor process is used to carry out the
database operations. This executor process inherits the privileges and authorization
characteristics from the server process that started it.
Thus the information as described above applies to the executor processes in exactly the
same manner as described for the server process.
8.3 Persona
When an Oracle JDBC for Rdb thin server is running, it assumes the default privileges and
identifiers of the user that started the server process. Similarly, when a SQL Services JDBC
Dispatcher starts a server, the server will inherit the privileges and identifiers of the
SQL/Services dispatcher process.
You can change this behaviour by specifying a persona value in the server definition for the
server in the XML-formatted configuration file, or by using the persona switch on the
command line when starting up the server.
When started with a persona, the server process will inherit its privileges and identifiers from
the named persona.
BYPASS and SYSPRV privileges are still disabled by default, see BYPASS Privilege
for
more details.
To start a server with a specific persona, you will need to be logged into an account that has
IMPERSONATE privilege and read access to the system authorization database.
The persona value associated with the server must be a valid OpenVMS persona on the
system you are running the server on.
See Server Configuration Options
for the format of the Persona option.
8.3.1 Persona and Server Operations
When persona is used with a server, you should ensure that the persona used has appropriate
access to the JDBC command procedures and JDBC log directories.
This is especially important if you use persona with a pool server or a multi-process server.
Before a server carries out any other operation it will assume the persona provided and then
by default disable BYPASS (see BYPASS Privilege
). So from that time on the server is
operating under the persona supplied and will be restricted to the rights and authorization
given to that persona.
110