�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2FSRC%2F'>SRC</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2F'>mariadb-11.7.2</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2F'>mysql-test</a>/<a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain%2F'>main</a>/</p><hr><h3>✏️ Editing: create_or_replace_permission.result</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>set local sql_mode=&quot;&quot;;
set global sql_mode=&quot;&quot;;
#
# Tests for checking permission denied on CREATE OR REPLACE if DROP
# access is revoked
#
# These statements do not need special tests for CREATE OR REPLACE,
# because they do not have separate permissions for create and drop:
# CREATE OR REPLACE EVENT (uses EVENT_ACL for both CREATE and DROP)
# CREATE OR DROP SERVER (uses SUPER_ALC for both CREATE and DROP)
# CREATE OR DROP TRIGGER (uses TRIGGER_ACL for both CREATE and DROP)
SELECT CURRENT_USER;
CURRENT_USER
root@localhost
CREATE DATABASE db1;
GRANT ALL ON db1.* TO mysqltest_1@localhost;
REVOKE DROP ON db1.* FROM mysqltest_1@localhost;
REVOKE ALTER ROUTINE ON db1.* FROM mysqltest_1@localhost;
GRANT DELETE ON mysql.* TO mysqltest_1@localhost;
REVOKE DELETE ON mysql.* FROM mysqltest_1@localhost;
FLUSH PRIVILEGES;
connect  user_a, localhost, mysqltest_1,,;
connection user_a;
SELECT CURRENT_USER;
CURRENT_USER
mysqltest_1@localhost
CREATE DATABASE db1;
ERROR HY000: Can&#039;t create database &#039;db1&#039;; database exists
CREATE OR REPLACE DATABASE db1;
ERROR 42000: Access denied for user &#039;mysqltest_1&#039;@&#039;localhost&#039; to database &#039;db1&#039;
CREATE OR REPLACE DATABASE db2;
ERROR 42000: Access denied for user &#039;mysqltest_1&#039;@&#039;localhost&#039; to database &#039;db2&#039;
USE db1;
CREATE OR REPLACE TABLE t1(id INT);
ERROR 42000: DROP command denied to user &#039;mysqltest_1&#039;@&#039;localhost&#039; for table `db1`.`t1`
CREATE OR REPLACE PROCEDURE proc1 (OUT cnt INT) BEGIN END;
ERROR 42000: alter routine command denied to user &#039;mysqltest_1&#039;@&#039;localhost&#039; for routine &#039;db1.proc1&#039;
CREATE OR REPLACE FUNCTION lookup RETURNS STRING SONAME &quot;UDF_EXAMPLE_LIB&quot;;
ERROR 42000: Access denied for user &#039;mysqltest_1&#039;@&#039;localhost&#039; to database &#039;mysql&#039;
CREATE OR REPLACE FUNCTION hello(str char(20)) RETURNS TEXT RETURN CONCAT(&#039;Hello, &#039;, str, &#039;!&#039;);
ERROR 42000: alter routine command denied to user &#039;mysqltest_1&#039;@&#039;localhost&#039; for routine &#039;db1.hello&#039;
CREATE OR REPLACE USER u1@localhost;
ERROR 42000: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
CREATE OR REPLACE ROLE developer;
ERROR 42000: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
connection default;
SELECT CURRENT_USER;
CURRENT_USER
root@localhost
REVOKE ALL ON db1.* FROM mysqltest_1@localhost;
DROP DATABASE IF EXISTS db2;
Warnings:
Note	1008	Can&#039;t drop database &#039;db2&#039;; database doesn&#039;t exist
DROP DATABASE db1;
DROP USER mysqltest_1@localhost;
set global sql_mode=default;
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2FSRC%2Fmariadb-11.7.2%2Fmysql-test%2Fmain'>🔙 Back</a></p>