Manage UltraLite users with SQL statements

You can use the CREATE USER, ALTER USER, and DELETE USER statements to manage users in an UltraLite database.

You cannot use these SQL statements with UltraLite Java edition databases.

Note

As an alternative to SQL statements, you can use the following UltraLite API methods in your application to grant or revoke user access to an UltraLite database:

Grant and revoke methods are not available in the UltraLiteJ API.

Example

The following example illustrates how to connect to an existing UltraLite database using the UltraLiteJ API, and use the CREATE USER statement to create a new user:

ConfigFile config = 
    DatabaseManager.createConfigurationFileAndroid("DBname.udb", getApplicationContext());
Connection conn = DatabaseManager.connect(config);

String sql_string = "CREATE USER test-user IDENTIFIED BY test-password";
PreparedStatement authenticator = conn.prepareStatement(sql_string);
authenticator.execute();
authenticator.close();