Figure 2-1 shows the procedure for setting user privileges.

Figure 2-1 Procedure for setting user privileges

Directory server linkage facility

When the directory server linkage facility is being used, the CONNECT privilege need be granted. For details about the directory server linkage facility, see 24. Using the Directory Server Linkage Facility.

Setting the audit privilege

For details about setting the audit privilege, see 22.4.3(1) Register the auditor.

Organization of this section

2.2.1 Granting the DBA privilege to users who manage user privileges

2.2.2 Granting the CONNECT privilege, schema definition privilege, and RDAREA usage privilege to users who create tables

2.2.3 Granting CONNECT and access privileges to users who access tables (database)