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

Creating an UltraLite user with SQL Central

Use SQL Central to create users for an UltraLite database.

Context

Note

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

  • ULConnection.GrantConnectTo method [UltraLite C++]
  • ULGrantConnectTo method [UltraLite Embedded SQL]
  • ULConnection.GrantConnectTo method [UltraLite.NET]

Grant methods are not available in the UltraLiteJ API. For Android devices, construct a CREATE 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. Right-click the Users folder, and click Start of the navigation path New Next navigation step User End of the navigation path.
  3. Follow the instructions in the wizard.

Results

The new user is created.