The facility for simple authentication of OS login users enables a HiRDB client to connect to the HiRDB server by using the same user name used to log into the OS on which the client is running. A user using the facility for simple authentication of OS login users is called a simple authenticated user. The facility for simple authentication of OS login users can be used only by a user to whom the CONNECT privilege as a simple authenticated user has been granted. The following figure shows the general procedure for connecting to the HiRDB server when the facility for simple authentication of OS login users is used.

Figure 2-2 General procedure for connecting to the HiRDB server when the facility for simple authentication of OS login users is used

Note that the schema definition privilege cannot be granted to simple authenticated users. Note also that users with the DBA privilege cannot create schemas for simple authenticated users. If you will be using the facility for simple authentication of OS login users, schemas must be created by users other than the simple authenticated users, and then permissions to access those schemas must be granted to the simple authenticated users. Because simple authenticated users cannot own schemas, they will use the access permissions that they have been granted to access resources, such as tables, owned by users who are not simple authenticated users.

Organization of this section

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

2.5.2 Using the facility for simple authentication of OS login users to connect to the HiRDB server

2.5.3 Application conditions for HiRDB password authentication and simple authentication of OS login users

2.5.4 Privileges that can be granted to simple authenticated users

2.5.5 Notes about using the facility for simple authentication of OS login users