Skip to Content

MaxDB Database Administration using JDBC – Part 2

In this weblog we can see how to use the DBMCLI commands to create, display, and delete user entries for MaxDB using JDBC. The necessary java programs for the same is given below along with the screen shots for the output.

The below links will be useful to learn more about the JDBC and MaxDB
MaxDB Documentation
JDBC Technology

1. Creating and Displaying DBMCLI users.

To create a new user first we must login as the DBM user with proper authorization for the same. The command that is used for the same is USER_LOGON. After logging into the DBMCLI we can execute the USER_CREATE command to create a new DBM user. The next task to get the details of a particular DBM user. In this weblog the properties of the newly created user ig being displayed using the command USER_GET


image

Verification Using the DBMCLI.

image

2. Displaying all the users and deleting a user

To display all the users avaliable we can use the USER_GETALL. Then the command to delete a particular user is USER_DELETE. The program given below illustrates how we can display all the available users and also to delete a particular user.


image

Verification Using the DBMCLI.

image

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply