MariaDB DBA Tools - Security Manager
Provides manageability of users, allowing the user to manage permissions of the MariaDB database.

Toolbar Operations -

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
Group by: Groups users by hostname or username
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

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
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 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
Create Role: Creates a new role
Alter Role: Edits selected role
Drop Role: Drops selected role
Role Properties: Shows properties of selected role

Tree Tab - Provides a tree display of users from the MariaDB database. Selecting an object in the tree structure displays a detailed view of the object on the right pane.

MariaDB DBA Tools - Security Manager - Tree Tab

Users Tab - Provides a list of users in the Oracle database

Name: Name of the user
Default Tablespace: Default tablespace for data
Temp Tablespace: Name of the default tablespace for temporary table or the name of a tablespace group
Profile: User resource profile name
Created Date: User creation date
Status: Account status
Locked Date: Date the account was locked
Expiration Date: Date the account expires



MariaDB DBA Tools - Security Manager - Users Tab

Roles Tab - Provides a list of roles in the Oracle database

Name: Name of the role
Password Required: Indicates if the role requires a password to be enabled
Authentication: Authentication that is required {NONE, PASSWORD, GLOBAL, EXTERNAL}

MariaDB DBA Tools - Security Manager - Roles Tab



  • No labels