Nonstop Database, HiRDB Version 9 System Operation Guide

[Contents][Index][Back][Next]

2.5.1 Preparations for using the facility for simple authentication of OS login users

Organization of this subsection
(1) Using a system definition to enable the facility for simple authentication of OS login users
(2) Specifying the simple authenticated users

(1) Using a system definition to enable the facility for simple authentication of OS login users

Specify the pd_os_authenticate system common definition to enable the facility for simple authentication of OS login users.

For details about the information to be specified in pd_os_authenticate, see Operand explanation in the manual HiRDB Version 9 System Definition.

(2) Specifying the simple authenticated users

Use the GRANT SQL statement to specify the users to whom the CONNECT privilege as a simple authenticated user is to be granted.

For details about using the GRANT statement to specify simple authenticated users, see GRANT Format 1 (Grant privileges) in the manual HiRDB Version 9 SQL Reference.

Note that simple authenticated users do not use the conventional HiRDB authentication method that requires entry of a password. The GRANT statement cannot be used to change the user authentication method. To change a privilege, you must first delete the existing privileges and then grant the new privileges.