Sybase - Security Manager

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 - Depending on the Tab selected, there are different Toolbar Operations available. Available operations for Logins & Server Roles tab Refresh : Refreshes all tabs in the security manager from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed Database: Chooses from which database you want to see the users and roles Expand All: Expands all tree nodes in the tree tab Collapse All: Collapses all tree nodes in the tree tab Create Login: Creates a new login Alter Login: Edits selected login Drop Login: Drops selected login Login Properties: Shows properties of selected login Create Server Role: Creates a new server role Alter Server Role: Edits selected server role Drop Server Role: Drops selected server role Server Role Properties: Shows properties of selected server role Available operations for Logins tab Refresh : Refreshes all tabs in the security manager from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else Database: Chooses from which database you want to see the users and roles Create Login: Creates a new login Alter Login: Edits selected login Drop Login: Drops selected login Login Properties: Shows properties of selected login Available operations for Server Roles tab Refresh : Refreshes all tabs in the security manager from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else Database: Chooses from which database you want to see the users and roles Create Server Role: Creates a new server role Alter Server Role: Edits selected server role Drop Server Role: Drops selected server role Server Role Properties: Shows properties of selected server role Available operations for Database Users & Roles tab Refresh : Refreshes all tabs in the security manager from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else Database: Chooses from which database you want to see the users and roles Expand All: Expands all tree nodes in the tree tab Collapse All: Collapses all tree nodes in the tree tab Create User: Creates a new user Alter User: Edits selected user Drop User: Drops selected user View User: Shows properties of selected user Create Group: Creates a new group Alter Group: Edits selected group Drop Group: Drops selected group View Group: Shows properties of selected group Available operations for Users tab Refresh : Refreshes all tabs in the security manager from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else Database: Chooses from which database you want to see the users and roles Create User: Creates a new user Alter User: Edits selected user Drop User: Drops selected user View User: Shows properties of selected user Available operations for Groups tab Refresh : Refreshes all tabs in the security manager from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else Database: Chooses from which database you want to see the users and roles Create Group: Creates a new group Alter Group: Edits selected group Drop Group: Drops selected group View Group: Shows properties of selected group Available operations for Roles tab Refresh : Refreshes all tabs in the security manager from the database Reconnect: Reconnects to the database server Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else Database: Chooses from which database you want to see the users and roles
Logins & Server Roles Tab - Provides a tree display of logins and server roles the Sybase database. Selecting an object in the tree structure displays a detailed view of the object on the right pane.	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
Roles Tab - Provides a list of roles in the Sybase database Name: Name of the role	Sybase DBA Tools - Security Manager - Roles Tab

Content

Space Tools