Sybase Security Manager - Manage Logins, Server Roles, Users and Groups

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 of logins, server roles, users and roles allowing the user to manage permissions, roles and security of the Sybase 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 Sybase 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 Sybase database Name: Name of the login Status: Status of the login if there are problems (locked, expired, insecure) Default Database: Name of the default database in which the user is put when connection established Language: User's default language Full Name: User's full name Created: Login creation date
Server Roles Tab - Provides a list of server roles in the Sybase database Name: Name of the server role
Database Users & Groups Tab - Provides a tree display of users and roles (groups) in the Sybase 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 Sybase database Name: Name of the user Login Name: User login name Group Name: User role (group) name
Groups Tab - Provides a list of roles (groups) in the Sybase database Name: Name of the role (group)

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