11.8.5 Changing the access privileges granted to an HADB user

To change an HADB user's access privileges, you need to revoke the unnecessary access privileges first, and then grant the necessary access privileges.

The procedure for changing access privileges follows.

Procedure

1. Check the access privileges granted to an HADB user.

   Check which access privileges have been granted to an HADB user based on the explanation in 11.8.2 Checking the access privileges granted to an HADB user.

2. Revoke the unnecessary access privileges that were granted to the HADB user.

   Execute the REVOKE statement based on the explanation in 11.8.3 Revoking access privileges that were granted to HADB users.

3. Grant the necessary access privileges to the HADB user.

   Execute the GRANT statement based on the explanation in 11.8.1 Granting access privileges to an HADB user.

To Page Top