Sybase DBA Tools - 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
|
Sybase DBA Tools - Security Manager - Logins and Server Roles Tab |
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
|
Sybase DBA Tools - Security Manager - Logins Tab |
Server Roles Tab - Provides a list of server roles in the Sybase database
Name: Name of the server role
|
Sybase DBA Tools - Security Manager - Server Roles Tab |
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
|
Sybase DBA Tools - Security Manager - Users and Groups Tab |
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
|
Sybase DBA Tools - Security Manager - Users Tab |
Groups Tab - Provides a list of roles (groups) in the Sybase database
Name: Name of the role (group)
|
Sybase DBA Tools - Security Manager - Groups Tab |
