Creating Database Projects with SQL Anywhere Studio, Part 2
(Page 1 of 5 )
In this second of two articles, you will learn about user management with Sybase Central, integrated logins, importing ASA data into an Excel worksheet, and more.
Introduction
In Part 1 of this two part article, SQL Anywhere Studio 9.0 installation, and interactive SQL tool were discussed. More importantly, starting and stopping the database server, creating sql statements and stored procedures were discussed.
In this tutorial, user managment will be discussed. Since databases have to be accessed, setting up user credentials, and giving permissions to ASPNET for Web applications will be discussed.
User Management with Sybase Central
Following procedures as outlined in the previous tutorial it should now be easy to start and stop the server, bring up Sybase Central and connect to the database, and also write and run queries. Now start the server and the Sybase Central management console. After this step, the server (network) should be running and Sybase Central should be showing the database as shown in the next picture.
In the left hand frame the Users and Groups node can be located. An expanded view of this is shown in the next picture. If you right click this node, you will be able to create a new user or new group.
If you agree to create a new user, you will open up a Create New User wizard. The next couple of pictures show the screens that you would encounter when creating a new user. Here a new user named "mysorian" is created. It will be necessary to create a password and, more importantly, to note it down as it will be used later in the program.
The next screen is important because it deals with the permitted role of the user and his access to resources. When in doubt, accept defaults.
When you click Finish, the user "mysorian" will be created, as you can see in the next picture. User "mysorian" does not yet belong to any group, but he has the same credentials as the DBA.
Next: Integrated Login >>
More Database Articles
More By Jayaram Krishnaswamy
/ 11 
