Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database schemas » UltraLite users

Deleting an UltraLite user with SQL Central

Use SQL Central to explicitly delete users from an UltraLite database.

Context

Note

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

  • ULConnection.RevokeConnectFrom method [UltraLite C++]
  • ULRevokeConnectFrom method [UltraLite Embedded SQL]
  • ULConnection.RevokeConnectFrom method [UltraLite.NET]

Revoke methods are not available in the UltraLiteJ API.construct a DROP USER statement as a string variable and pass it to the Connection.prepareStatement method.

Procedure

  1. Using SQL Central, connect to the UltraLite database.
  2. In the left pane, double-click the Users folder.
  3. Right-click the user and click Delete.

Results

The user is deleted from the database.