Rimuovere Utenti Dal SQL Server - Cronologia

Skid il 22:21, 13 mag 2021

2021-05-13T22:21:29Z

← Versione meno recente		Versione delle 22:21, 13 mag 2021
Riga 64:		Riga 64:
	<br>		<br>
	MariaDB [(none)]><br>		MariaDB [(none)]><br>
	</div>Sarebbe opportuno aggiungere che, come riportato dal [https://mariadb.com/kb/it/drop-user/ Manuale], se sul sistema è in uso [https://mariadb.com/ MariaDB], l'esecuzione della query '''<code>DROP USER</code>''' comporta anche la rimozione di tutte le righe delle tabelle grant che impostano privilegi per l'utente oggetto della nostra azione, rendendo di fatto non più necessaria la rimozione preventiva dei privilegi. Tuttavia questa procedura resta una pratica di buona gestione del sistema.		</div>


			Sarebbe opportuno aggiungere che, come riportato dal [https://mariadb.com/kb/it/drop-user/ Manuale], se sul sistema è in uso [https://mariadb.com/ MariaDB], l'esecuzione della query '''<code>DROP USER</code>''' comporta anche la rimozione di tutte le righe delle tabelle grant che impostano privilegi per l'utente oggetto della nostra azione, rendendo di fatto non più necessaria la rimozione preventiva dei privilegi. Tuttavia questa procedura resta una pratica di buona gestione del sistema.

Skid il 22:20, 13 mag 2021

2021-05-13T22:20:33Z

← Versione meno recente		Versione delle 22:20, 13 mag 2021
Riga 3:		Riga 3:
	[[Category:sysadmin]]		[[Category:sysadmin]]
	[[Category:Database]]		[[Category:Database]]
	il comando '''<code>DROP USER</code>''' rimuove un utente dal SQL Server ma e' bene precisare che da solo esso non e' sufficiente ~~in quanto il rimuovere l~~'utente non si concretizza con la contemporanea rimozione dei permessi ad esso correlati.		il comando '''<code>DROP USER</code>''' rimuove un utente dal SQL Server ma e' bene precisare che da solo esso non e' sufficiente, la rimozione dell'utente (generalmente) non si concretizza con la contemporanea rimozione dei permessi ad esso correlati.

	Si procede per tanto come segue:		Si procede per tanto come segue:

	Rimozione dei privilegi:		Rimozione dei privilegi;

	<div id="atscreen">		<div id="atscreen">
	MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';<br>		MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';<br>
	~~<br>~~
	+-------------------------------------------------------------------------------------------------------+<br>		+-------------------------------------------------------------------------------------------------------+<br>
	\| Grants for iu6crh@%                                                                                   \|<br>		\| Grants for iu6crh@%                                                                                   \|<br>
Riga 31:		Riga 30:
	1 row in set (0.00 sec)<br>		1 row in set (0.00 sec)<br>
	<br>		<br>
	MariaDB [(none)]>		MariaDB [(none)]> FLUSH PRIVILEGES;<br>
			Query OK, 0 rows affected (0.00 sec)<br>
			<br>
			MariaDB [(none)]><br>
	</div>		</div>

	Rimozione dell'utente:
			Rimozione dell'utente;

	<div id="atscreen">		<div id="atscreen">
Riga 46:		Riga 49:
	2 rows in set (0.00 sec)<br>		2 rows in set (0.00 sec)<br>
	<br>		<br>
	MariaDB [(none)]> ~~drop user~~ iu6crh;<br>		MariaDB [(none)]> DROP USER iu6crh;<br>
	Query OK, 0 rows affected (0.00 sec)<br>		Query OK, 0 rows affected (0.00 sec)<br>
	<br>		<br>
Riga 57:		Riga 60:
	1 row in set (0.00 sec)<br>		1 row in set (0.00 sec)<br>
	<br>		<br>
	MariaDB [(none)]>		MariaDB [(none)]> FLUSH PRIVILEGES;<br>
	</div>		Query OK, 0 rows affected (0.00 sec)<br>
			<br>
			MariaDB [(none)]><br>
			</div>Sarebbe opportuno aggiungere che, come riportato dal [https://mariadb.com/kb/it/drop-user/ Manuale], se sul sistema è in uso [https://mariadb.com/ MariaDB], l'esecuzione della query '''<code>DROP USER</code>''' comporta anche la rimozione di tutte le righe delle tabelle grant che impostano privilegi per l'utente oggetto della nostra azione, rendendo di fatto non più necessaria la rimozione preventiva dei privilegi. Tuttavia questa procedura resta una pratica di buona gestione del sistema.

Skid il 22:01, 13 mag 2021

2021-05-13T22:01:12Z

← Versione meno recente		Versione delle 22:01, 13 mag 2021
Riga 41:		Riga 41:
	\| User   \| Host      \| Password                                  \| password_expired \|<br>		\| User   \| Host      \| Password                                  \| password_expired \|<br>
	+--------+-----------+-------------------------------------------+------------------+<br>		+--------+-----------+-------------------------------------------+------------------+<br>
	\| root \| localhost \|                                           \| N                \|<br>		\| root   \| localhost \|                                           \| N                \|<br>
	\| iu6crh \| %         \| *6DA413D8ACD33A112877D31A8BD9DDFB36411631 \| N                \|<br>		\| iu6crh \| %         \| *6DA413D8ACD33A112877D31A8BD9DDFB36411631 \| N                \|<br>
	+--------+-----------+-------------------------------------------+------------------+<br>		+--------+-----------+-------------------------------------------+------------------+<br>

Skid il 22:00, 13 mag 2021

2021-05-13T22:00:13Z

← Versione meno recente		Versione delle 22:00, 13 mag 2021
Riga 13:		Riga 13:
	<br>		<br>
	+-------------------------------------------------------------------------------------------------------+<br>		+-------------------------------------------------------------------------------------------------------+<br>
	\| Grants for iu6crh@% \|<br>		\| Grants for iu6crh@%                                                                                   \|<br>
	+-------------------------------------------------------------------------------------------------------+<br>		+-------------------------------------------------------------------------------------------------------+<br>
	\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|<br>		\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|<br>
	\| GRANT ALL PRIVILEGES ON `hamlog`.* TO 'iu6crh'@'%' \|<br>		\| GRANT ALL PRIVILEGES ON `hamlog`.* TO 'iu6crh'@'%'                                                    \|<br>
	+-------------------------------------------------------------------------------------------------------+<br>		+-------------------------------------------------------------------------------------------------------+<br>
	2 rows in set (0.00 sec)<br>		2 rows in set (0.00 sec)<br>
Riga 25:		Riga 25:
	MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';<br>		MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';<br>
	+-------------------------------------------------------------------------------------------------------+<br>		+-------------------------------------------------------------------------------------------------------+<br>
	\| Grants for iu6crh@% \|<br>		\| Grants for iu6crh@%                                                                                   \|<br>
	+-------------------------------------------------------------------------------------------------------+<br>		+-------------------------------------------------------------------------------------------------------+<br>
	\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|<br>		\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|<br>
Riga 39:		Riga 39:
	MariaDB [(none)]> SELECT User, Host, Password, password_expired FROM mysql.user;<br>		MariaDB [(none)]> SELECT User, Host, Password, password_expired FROM mysql.user;<br>
	+--------+-----------+-------------------------------------------+------------------+<br>		+--------+-----------+-------------------------------------------+------------------+<br>
	\| User \| Host \| Password \| password_expired \|<br>		\| User   \| Host      \| Password                                  \| password_expired \|<br>
	+--------+-----------+-------------------------------------------+------------------+<br>		+--------+-----------+-------------------------------------------+------------------+<br>
	\| root \| localhost \| \| N \|<br>		\| root \| localhost \|                                           \| N                \|<br>
	\| iu6crh \| % \| *6DA413D8ACD33A112877D31A8BD9DDFB36411631 \| N \|<br>		\| iu6crh \| %         \| *6DA413D8ACD33A112877D31A8BD9DDFB36411631 \| N                \|<br>
	+--------+-----------+-------------------------------------------+------------------+<br>		+--------+-----------+-------------------------------------------+------------------+<br>
	2 rows in set (0.00 sec)<br>		2 rows in set (0.00 sec)<br>
Riga 51:		Riga 51:
	MariaDB [(none)]> SELECT User, Host, Password, password_expired FROM mysql.user;<br>		MariaDB [(none)]> SELECT User, Host, Password, password_expired FROM mysql.user;<br>
	+------+-----------+----------+------------------+<br>		+------+-----------+----------+------------------+<br>
	\| User \| Host \| Password \| password_expired \|<br>		\| User \| Host      \| Password \| password_expired \|<br>
	+------+-----------+----------+------------------+<br>		+------+-----------+----------+------------------+<br>
	\| root \| localhost \| \| N \|<br>		\| root \| localhost \|          \| N                \|<br>
	+------+-----------+----------+------------------+<br>		+------+-----------+----------+------------------+<br>
	1 row in set (0.00 sec)<br>		1 row in set (0.00 sec)<br>

Skid il 21:53, 13 mag 2021

2021-05-13T21:53:50Z

← Versione meno recente		Versione delle 21:53, 13 mag 2021
Riga 10:		Riga 10:

	<div id="atscreen">		<div id="atscreen">
	MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';		MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';<br>
			<br>
	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+<br>
	\| Grants for iu6crh@% \|		\| Grants for iu6crh@% \|<br>
	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+<br>
	\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|		\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|<br>
	\| GRANT ALL PRIVILEGES ON `hamlog`.* TO 'iu6crh'@'%' \|		\| GRANT ALL PRIVILEGES ON `hamlog`.* TO 'iu6crh'@'%' \|<br>
	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+<br>
	2 rows in set (0.00 sec)		2 rows in set (0.00 sec)<br>

	~~MariaDB [(none)]~~> ~~REVOKE ALL privileges ON hamlog.* FROM 'iu6crh'@'%';~~
	~~Query OK, 0 rows affected (0.00 sec)~~

	~~MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';~~
	~~+-------------------------------------------------------------------------------------------------------+~~
	~~\| Grants for iu6crh@% \|~~
	~~+-------------------------------------------------------------------------------------------------------+~~
	~~\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|~~
	~~+-------------------------------------------------------------------------------------------------------+~~
	~~1 row in set (0.00 sec)~~

			MariaDB [(none)]> REVOKE ALL privileges ON hamlog.* FROM 'iu6crh'@'%';<br>
			Query OK, 0 rows affected (0.00 sec)<br>
			<br>
			MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';<br>
			+-------------------------------------------------------------------------------------------------------+<br>
			\| Grants for iu6crh@% \|<br>
			+-------------------------------------------------------------------------------------------------------+<br>
			\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|<br>
			+-------------------------------------------------------------------------------------------------------+<br>
			1 row in set (0.00 sec)<br>
			<br>
	MariaDB [(none)]>		MariaDB [(none)]>
	</div>		</div>
Riga 37:		Riga 37:

	<div id="atscreen">		<div id="atscreen">
	MariaDB [(none)]> SELECT User, Host, Password, password_expired FROM mysql.user;		MariaDB [(none)]> SELECT User, Host, Password, password_expired FROM mysql.user;<br>
	+--------+-----------+-------------------------------------------+------------------+		+--------+-----------+-------------------------------------------+------------------+<br>
	\| User \| Host \| Password \| password_expired \|		\| User \| Host \| Password \| password_expired \|<br>
	+--------+-----------+-------------------------------------------+------------------+		+--------+-----------+-------------------------------------------+------------------+<br>
	\| root \| localhost \| \| N \|		\| root \| localhost \| \| N \|<br>
	\| iu6crh \| % \| *6DA413D8ACD33A112877D31A8BD9DDFB36411631 \| N \|		\| iu6crh \| % \| *6DA413D8ACD33A112877D31A8BD9DDFB36411631 \| N \|<br>
	+--------+-----------+-------------------------------------------+------------------+		+--------+-----------+-------------------------------------------+------------------+<br>
	2 rows in set (0.00 sec)		2 rows in set (0.00 sec)<br>
			<br>
	MariaDB [(none)]> drop user iu6crh;		MariaDB [(none)]> drop user iu6crh;<br>
	Query OK, 0 rows affected (0.00 sec)		Query OK, 0 rows affected (0.00 sec)<br>
			<br>
	MariaDB [(none)]> SELECT User, Host, Password, password_expired FROM mysql.user;		MariaDB [(none)]> SELECT User, Host, Password, password_expired FROM mysql.user;<br>
	+------+-----------+----------+------------------+		+------+-----------+----------+------------------+<br>
	\| User \| Host \| Password \| password_expired \|		\| User \| Host \| Password \| password_expired \|<br>
	+------+-----------+----------+------------------+		+------+-----------+----------+------------------+<br>
	\| root \| localhost \| \| N \|		\| root \| localhost \| \| N \|<br>
	+------+-----------+----------+------------------+		+------+-----------+----------+------------------+<br>
	1 row in set (0.00 sec)		1 row in set (0.00 sec)<br>
			<br>
	MariaDB [(none)]>		MariaDB [(none)]>
	</div>		</div>

Skid il 21:51, 13 mag 2021

2021-05-13T21:51:00Z

Skid il 21:49, 13 mag 2021

2021-05-13T21:49:12Z

← Versione meno recente		Versione delle 21:49, 13 mag 2021
Riga 10:		Riga 10:

	<div id="atscreen">		<div id="atscreen">
	MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';		MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	\| Grants for iu6crh@% \|		\| Grants for iu6crh@% \|

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|		\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|

	\| GRANT ALL PRIVILEGES ON `hamlog`.* TO 'iu6crh'@'%' \|		\| GRANT ALL PRIVILEGES ON `hamlog`.* TO 'iu6crh'@'%' \|

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	2 rows in set (0.00 sec)		2 rows in set (0.00 sec)


	MariaDB [(none)]> REVOKE ALL privileges ON hamlog.* FROM 'iu6crh'@'%';		MariaDB [(none)]> REVOKE ALL privileges ON hamlog.* FROM 'iu6crh'@'%';

	Query OK, 0 rows affected (0.00 sec)		Query OK, 0 rows affected (0.00 sec)

	MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';
			MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	\| Grants for iu6crh@% \|		\| Grants for iu6crh@% \|

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|		\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	1 row in set (0.00 sec)		1 row in set (0.00 sec)

Skid il 21:46, 13 mag 2021

2021-05-13T21:46:11Z

@@ Riga 7: / Riga 7: @@
 Si procede per tanto come segue:
-Rimozione dei privilegi
+Rimozione dei privilegi:
- REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'editore'@'localhost'
+<div id="atscreen">
-Rimozione dell'utente
+MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';
-DROP USER 'editore'@'localhost'
+MariaDB [(none)]> REVOKE ALL privileges ON hamlog.* FROM 'iu6crh'@'%';

Skid il 18:07, 13 mag 2021

2021-05-13T18:07:59Z

← Versione meno recente		Versione delle 18:07, 13 mag 2021
Riga 3:		Riga 3:
	[[Category:sysadmin]]		[[Category:sysadmin]]
	[[Category:Database]]		[[Category:Database]]
	il comando DROP USER rimuove un utente dal SQL Server ma e' bene precisare che da solo esso non e' sufficiente in quanto il rimuovere l'utente non si concretizza con la contemporanea rimozione dei permessi ad esso correlati.		il comando '''<code>DROP USER</code>''' rimuove un utente dal SQL Server ma e' bene precisare che da solo esso non e' sufficiente in quanto il rimuovere l'utente non si concretizza con la contemporanea rimozione dei permessi ad esso correlati.

	Si procede per tanto come segue:		Si procede per tanto come segue:

Skid il 18:06, 13 mag 2021

2021-05-13T18:06:58Z

← Versione meno recente		Versione delle 18:06, 13 mag 2021
Riga 3:		Riga 3:
	[[Category:sysadmin]]		[[Category:sysadmin]]
	[[Category:Database]]		[[Category:Database]]
			il comando DROP USER rimuove un utente dal SQL Server ma e' bene precisare che da solo esso non e' sufficiente in quanto il rimuovere l'utente non si concretizza con la contemporanea rimozione dei permessi ad esso correlati.

			Si procede per tanto come segue:

			Rimozione dei privilegi

			REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'editore'@'localhost'
			Rimozione dell'utente

			DROP USER 'editore'@'localhost'

← Versione meno recente		Versione delle 21:51, 13 mag 2021
Riga 13:		Riga 13:

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	\| Grants for iu6crh@% \|		\| Grants for iu6crh@% \|

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|		\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|

	\| GRANT ALL PRIVILEGES ON `hamlog`.* TO 'iu6crh'@'%' \|		\| GRANT ALL PRIVILEGES ON `hamlog`.* TO 'iu6crh'@'%' \|

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	2 rows in set (0.00 sec)		2 rows in set (0.00 sec)


	MariaDB [(none)]> REVOKE ALL privileges ON hamlog.* FROM 'iu6crh'@'%';		MariaDB [(none)]> REVOKE ALL privileges ON hamlog.* FROM 'iu6crh'@'%';

	Query OK, 0 rows affected (0.00 sec)		Query OK, 0 rows affected (0.00 sec)


	MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';		MariaDB [(none)]> SHOW GRANTS FOR 'iu6crh'@'%';

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	\| Grants for iu6crh@% \|		\| Grants for iu6crh@% \|

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|		\| GRANT USAGE ON . TO 'iu6crh'@'%' IDENTIFIED BY PASSWORD '*6DA413D8ACD33A112877D31A8BD9DDFB36411631' \|

	+-------------------------------------------------------------------------------------------------------+		+-------------------------------------------------------------------------------------------------------+

	1 row in set (0.00 sec)		1 row in set (0.00 sec)