You can delete a user from the database using both Sybase Central and Interactive SQL. The user being removed cannot be connected to the database during this procedure.
Deleting a user also deletes all database objects (such as tables) that they own, as well as any external logins for the user.
Only a user with DBA authority can delete a user.
To delete a user from the database (Sybase Central)Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
Click Users & Groups.
Right-click a user and then choose Delete.
Click Yes.
To delete a user from the database (SQL)Connect to the database as a user with DBA authority.
Execute a DROP USER statement.
Example See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |