mirror of
https://github.com/MariaDB/server.git
synced 2025-08-02 00:21:35 +02:00
ce7ab467db
DROP USER looks for sessions by the do-be-dropped user and if found: * fails with ER_CANNOT_USER in Oracle mode * continues with ER_ACTIVE_CONNECTIONS_FOR_USER_TO_DROP warning otherwise Every user being dropped is marked with flag that disallow establishing a new connections on behalf this user.
26 lines
621 B
Text
26 lines
621 B
Text
#
|
|
# Test password expiration
|
|
#
|
|
|
|
--source include/not_embedded.inc
|
|
--source include/have_unix_socket.inc
|
|
|
|
--echo #
|
|
--echo # A password cannot expire, if there is no password
|
|
--echo #
|
|
|
|
--let $replace=create user '$USER'
|
|
--replace_result $replace "create user 'USER'"
|
|
--eval create user '$USER' identified via unix_socket
|
|
|
|
--let $replace=alter user '$USER'
|
|
--replace_result $replace "alter user 'USER'"
|
|
--eval alter user '$USER' password expire
|
|
|
|
--exec $MYSQL -u $USER -e 'select 1'
|
|
|
|
--let $replace=drop user '$USER'
|
|
--replace_result $replace "drop user 'USER'"
|
|
--disable_warnings
|
|
--eval drop user '$USER'
|
|
--enable_warnings
|