You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

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

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.

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


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}



  • No labels