You can create new users in both Sybase Central and Interactive SQL. In Sybase Central, you manage users or groups in the Users & Groups folder. In Interactive SQL, you can add a new user using the CREATE USER statement. For both tools, you need DBA authority to create new users.
All new users are automatically added to the PUBLIC group. Once you have created a new user, you can:
add the user to other groups. See Granting group membership to existing users or groups.
set the user's permissions on tables, views, and procedures. See Managing user permissions and authorities.
set the user as the publisher or as a remote user of the database. See User permissions.
assign a login policy to the user. By default, a user is assigned to the root login policy. However, you can create and assign custom login policies. See Managing login policies.
Initial permissions for new users Restrictions on user IDs and passwords |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |