SQL Server Security Manager - Manage Logins, Server Roles, Users and Roles

Documentation: Aqua Data Studio 6.0 - New Features		HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)

Getting Started

Installation

JDBC Drivers

Oracle

II.

DB2 UDB

III.	SQL Server

IV.	Sybase ASE

V.	Sybase Anywhere

VI.

Sybase IQ

VII.

Informix

VIII.

PostgreSQL

IX.

MySQL

Memory Configuration

Character sets

Registering Servers

MSDE 2000

II.	SQL Express 2005

III.	PostgreSQL SSL

Application

I.	Browser and Scripting

II.	Visual Editing

III.	SQL History

IV.	Shortcut Toolbar

V.	Key Mappings

VI.	Custom Keymap Profiles

VII.

Options

VIII.

Settings

Query Window

Basics

II.

Toolbar

III.	Server Side Comments

IV.	SQL Automation

V.	Variable Binding

VI.

Results

VII.	Save Results

VIII.

Auto-completion

IX.	SQL Formatter

X.	Permissions

XI.	Parameterized

Editors

I.	SQL Editor

II.	Text Editor

III.	HTML Editor

IV.	XML Editor

V.	Regular Expressions

Image Viewer

Visual Explain Plan

Basics

II.	Explain Plan

III.	Explain Diagram

IV.	Whiteboard

Procedure/Package Editor

Tools

I.	Table Data Editor

II.	Script Generator

III.	ER Diagram

IV.	Query Builder

V.	Import Tool

VI.	Export Tool

VII.	Execution Monitor

Difference Tools

I.	Schema Diff

II.

Tab Diff

III.	Directory Diff

IV.

File Diff

V.	Copy History Diff

Oracle DBA Tools

I.	Instance Manager

II.	Storage Manager

III.	Rollback Manager

IV.	Log Manager

V.	Security Manager

VI.	Session Manager

VII.	SGA Manager

VIII.

Server Statistics

SQL Server DBA Tools

I.	Instance Manager

II.	Storage Manager

III.	Security Manager

IV.	Session Manager

V.	SQL Agent Manager

Sybase DBA Tools

I.	Instance Manager

II.	Storage Manager

III.	Security Manager

IV.	Session Manager

Security Manager - Provides manageability for logins, server roles, users, roles and profiles allowing a user to manage permissions, roles and security of the MS SQL database.
Toolbar Operations - Refresh : Will refresh all tabs in the security manager from the database Expand All: Expands all tree nodes in the tree tab Collapse All: Collapses all tree nodes in the tree tab Create Login: Create a new login Alter Login: Edit selected login Drop Login: Drop selected login Login Properties: View properties of selected login Alter Server Role: Edit selected server role Server Role Properties: View properties of selected server role Create User: Create a new user Alter User: Edit selected user Drop User: Drop selected user User Properties: View properties of selected user Create Role: Create a new role (group) Alter Role: Edit selected role Drop Role: Drop selected role Role Properties: View properties of selected role
Logins & Server Roles Tab - Provides a tree display of logins and server roles the MS SQL database. Selecting an object in the tree structure will display a detailed view of the object
Logins Tab - Provides a list of logins in the MS SQL database Name: Name of the login Type: Login type(NT User, NT Group, Standard) Access: Whether the login has been granted access to the server Default Database: Name of the default database of the user when a connection is established Has Roles: Whether the login has roles Date Created: Date when the login was created
Server Roles Tab - Provides a list of server roles in the MS SQL database Full Name: Descriptive name of the server role Name: Short name of the server role Description: Detailed description of the server role
Database Users & Roles Tab - Provides a tree display of users and roles (groups) in the MS SQL database. Selecting an object in the tree structure will display a detailed view of the object
Users Tab - Provides a list of users in the MS SQL database Name: Name of the user Login Name: User login name Access: Whether the user has been granted access to the server
Roles Tab - Provides a list of roles in the MS SQL database Name: Name of the role (group) Type: Role type (application, standard)

Home • Screenshots • Downloads • Documentation • Support • Licensing • Contact