The security section allows you to manage the currently selected database. The objects that you can manage in this section are:

Users

Roles

Schemas

Asymmetric Keys

Certificates

Symmetric Keys

Clicking on the Users node lists all the users that belong to the currently selected database. You will also be able to add a new user

Figure 23

You create a new user by providing username, login name, default schema, specify schemas owned by the user, and the roles the user belong to.

Roles

This section allows you to manage database roles. You can create/modify/delete roles in a similar manner to creating and modifying users

Figure 24

Schemas

The schemas section is much similar to the above two sections. You can create/modify/delete schemas from your database. In SQL Server 2005, a schema is more like a container that can contain tables, stored procedures, and other database objects. It is a logical grouping of the database objects.

Creating a new schema is a very simply task to do

Figure 25

The Asymmetric Keys, Certificates, and Symmetric Keys nodes are added to myLittleAdmin just to view and delete current objects only.