Create a user by using the CREATE USER statement.
You must have the MANAGE ANY USER system privilege.
Context and remarks
User IDs cannot:
Passwords are case-sensitive and they cannot:
Connect to the database.
Execute a CREATE USER statement that contains an IDENTIFIED BY clause.
By default, users are assigned the root login policy. If you need to assign a user a different login policy, you can specify it by using the LOGIN POLICY clause of the CREATE USER statement.
This example adds a new user to the database with the user ID of M_Haneef and a password of Welcome.
CREATE USER M_Haneef IDENTIFIED BY Welcome;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|