Working with MyLittleAdmin - Management Tool for SQL Server 2005
page 13 of 20
by Bilal Haidar
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 86665/ 203

Security

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.


View Entire Article

User Comments

Title: Remote Machine Problem   
Name: Utsab
Date: 2012-01-29 8:17:14 AM
Comment:
It tells how to configure the tool for own machine or local machine. But in case of remote machine how to access the database with this MyLittleAdmin?
Title: sql server   
Name: kashif masood
Date: 2009-10-23 9:36:44 AM
Comment:
Excellent work and very descriptive specially with all those screenshots
Title: Working with MyLittleAdmin - Management Tool for SQL Server 2005   
Name: arindam1802@yahoo.com
Date: 2007-02-23 11:37:42 AM
Comment:
Excellent work and very descriptive specially with all those screenshots.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-12-04 5:59:18 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search