(An Untitled Masterwork)
ActivePublic
Actions

Authored by Marostegui on Jun 11 2018, 5:49 PM.

Tags

None

Referenced Files

	F21951260:
	Jun 11 2018, 5:49 PM

Subscribers

None

	mysql:root@localhost [(none)]> revoke SELECT, SHOW VIEW ON `sahwikiquote\_p`.* FROM 'labsdbuser';
	Query OK, 0 rows affected (0.00 sec)

	mysql:root@localhost [(none)]> pager grep sahwiki; show grants for labsdbuser;
	PAGER set to 'grep sahwiki'
	\| GRANT SELECT, SHOW VIEW ON `sahwikisource\_p`.* TO 'labsdbuser' \|
	\| GRANT SELECT, SHOW VIEW ON `sahwiki\_p`.* TO 'labsdbuser' \|
	891 rows in set (0.00 sec)



	root@labsdb1010:~# mysql -umaintainviews -p --skip-ssl
	Enter password:
	Welcome to the MariaDB monitor. Commands end with ; or \g.
	Your MariaDB connection id is 7119399
	Server version: 10.1.33-MariaDB MariaDB Server

	Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

	Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

	mysql:maintainviews@localhost [(none)]> set session sql_log_bin=0;
	Query OK, 0 rows affected (0.00 sec)

	mysql:maintainviews@localhost [(none)]> GRANT SELECT, SHOW VIEW ON `sahwikiquote\_p`.* TO 'labsdbuser';
	Query OK, 0 rows affected (0.00 sec)

	mysql:maintainviews@localhost [(none)]> create database sahwikiquote_p;
	Query OK, 1 row affected (0.00 sec)

Event Timeline

Marostegui created this paste.Jun 11 2018, 5:49 PM

mysql:root@localhost [(none)]> revoke SELECT, SHOW VIEW ON `idwikimedia\_p`.* FROM 'labsdbuser';
Query OK, 0 rows affected (0.00 sec)

mysql:root@localhost [(none)]> Ctrl-C -- exit!
Aborted
root@labsdb1010:~# mysql -uroot --skip-ssl
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 7135706
Server version: 10.1.33-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql:root@localhost [(none)]> pager grep idwikimedi; show grants for labsdbuser;
PAGER set to 'grep idwikimedi'
890 rows in set (0.00 sec)

mysql:root@localhost [(none)]> Ctrl-C -- exit!
Aborted
root@labsdb1010:~# mysql -umaintainviews -p --skip-ssl -e "create database idwikimedia_p;"
Enter password:
ERROR 1044 (42000) at line 1: Access denied for user 'maintainviews'@'localhost' to database 'idwikimedia_p'

(An Untitled Masterwork)ActivePublicActions

Event Timeline

(An Untitled Masterwork)
ActivePublic
Actions