Securich - A Security and User Administration plugin for MySQL
Sign in to YouTube
Sign in to YouTube
Sign in to YouTube
Uploaded on Apr 20, 2010
Darren Cassar (Trading Screen Inc) speaks at the 2010 O'Reilly MySQL User Conference & Expo.
From the official conference description at http://en.oreilly.com/mysql2010/publi...
How often do you wonder about the privileges a particular user has on databases, tables and stored procedures? Have you ever thought about which users have access to table passwords in livedb? Do all my users have a decent password? and When was it changed last? are surely issues DBAs commonly think about, whilst hoping users are not cycling through the usual three passwords to avoid having to remember a new one. Maybe you have occasionally granted full access to all tables in a database to avoid the frustration of having to grant on tables one by one, or wondered about the mess your users and their privileges were in. Did you ever wish you could rename a user paul'192.168.0.189' to 'paul'192.168.0.188 or clone userjohn'localhost' from 'fred'127.0.0.1? Then, perhaps, Securich can come to your rescue. It can easily tackle the above and much more. Securich also enables the absent roles functionality in MySQL, permits dynamic updating of roles and immediate rollout of the changes to each user.
Securich is very simple to install and update using a bash script that includes error catching and rollback in case of problems. Securich is also easy to be remove if required, a single drop securich command does the trick and does not change any of the rights granted to users through it.
Securich Features 1. Roles (Dynamic)
2. Password history
3. User cloning
4. Secured user (avoiding password-less accounts)
5. Configurable password complexity length, uppercase, lowercase, special characters, dictionary check
6. The possibility to revoke privileges from a single table (grant access to all tables in a database but one)
7. User blocking / unblocking
8. Immediate revoking of Privileges and Isolation of User
9. Auditing of privileges granted / revoked
10. Auditing of role updates
11. Reconciliation between MySQL and Securich
SAM-My is a web based, cross-platform, OS independent and lightweight application written in PHP, enabling GUI administration of users and configuration of the main parts of SECURICH.
SAM-My Features 1. Connection to MySQL and logout function
2. UI list of accounts and viewing of their rights
3. Granting and revoking of privileges
4. User cloning
5. Other features from Securich
6. Version check of Securich, MySQL and other details about the data server
Adding to its appeal is the fact that both Securich and SAM-My are OpenSource projects licensed under GPLv2.
Standard YouTube License
- 40:14 MySQL Plugin API: New Featuresby tcation286 views
- 53:32 New Replication Featuresby tcation930 views
- 39:07 Scalability and Reliability Features of MySQL Connector/Jby tcation869 views
- 47:30 MySQL Cluster: An Introductionby tcation9,168 views
- 8:54 Oracle DB Vs MySQL for Enterprise DataBase Deploymentsby Brandon Wirtz6,766 views
- 6:51 mySQL problem what to do?!?!?!by TwinkYzzz1,558 views
- 6:02 MySQL Administrationby Gunabalan Sellan2,356 views
- 28:41 Introduction to MySQL for Website Administratorsby Eli the Computer Guy27,641 views
- 6:29 How to install php and MySQL with Abyss webserver - 001 - Windows OSby windowsxpc4,581 views
- 2:23 Sam Broadcaster MYSQL Problemby RBGuides2,927 views
- 0:26 MySQL: Download and install SQLyogby mysqlmylife2,513 views
- 51:02 An Introduction to SQLiteby GoogleTechTalks52,384 views
- 6:36 AIX - User Administration - Part 2by Sivasankaran Rajarathinam19,359 views
- 8:52 Michael Widenius interviewed at MySQL Conference 2010by OreillyMedia811 views
- 7:34 Roles y usuariosby Syrokosmt3,662 views
- 37:27 Security Around MySQLby tcation809 views
- 0:57 Interactive Blend 03.aviby Brad Whistler253 views
- 39:21 PHP Programming Part 1: Introduction to PHP Programmingby Eli the Computer Guy156,450 views
- 40:49 Introduction to InnoDB Monitoring System and Resource & Performance Tuningby tcation1,480 views
- 15:00 Learn PHP in 15 minutesby Jake Wright50,686 views
- Loading more suggestions...