Search Results
https://dev.mysql.com/doc/refman/8.4/en/grant.html
[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role [, user_or_role] ... GRANT either succeeds for all named users and roles or rolls back and has no effect ...These syntax restrictions apply: GRANT cannot mix granting both privileges and roles in the same ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. Modifications occur indirectly when you use account-management statements such as CREATE USER, GRANT, and REVOKE ...The discussion here describes the underlying structure of the grant tables and how the server uses their contents when interacting with ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-granting-privileges-bulk-ingest.html
Do the following to grant the LOAD_FROM_S3 privilege to a user: Connect to the DB System. Grant the LOAD_FROM_S3 privilege to the user: GRANT LOAD_FROM_S3 ON *.* TO <User> Parent topic: Bulk Ingest Feature . Granting Privileges to Bulk Ingest Data ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
LDAP pluggable authentication provides these capabilities: External authentication: LDAP authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables in LDAP directories. This demonstrates that proxying ...MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use LDAP (Lightweight Directory Access Protocol) to authenticate MySQL users by accessing directory services such as ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 3836; Symbol: ER_UKNOWN_AUTH_ID_OR_ACCESS_DENIED_FOR_GRANT_AS; SQLSTATE: HY000 Message: Either some of the authorization IDs in the AS clause are invalid or the current user lacks privileges to execute the statement. Error number: ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
Each user can be granted a given single role to, in effect, be granted the appropriate set of privileges. The account for the proxied user must exist and be granted the privileges to be assumed by the proxy user. Granting and Revoking the PROXY ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
role [, role ] ...: Set the default to the named roles, which must exist and be granted to the account at the time ALTER USER ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ... In most cases, ALTER USER requires the global ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
Whether a privilege is static or dynamic affects its availability to be granted to user accounts and roles. For routines that fall within the scope at which the privilege is granted and for which the user is not the user named as the routine ... The ...These privileges are global because they are not specific to a particular ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
To perform the user-creation operation without either of these, drop the orphan objects, create the account and grant its privileges, and then re-create the dropped objects. You should be aware that, while MySQL 8.4 treats grants made to such a user ... CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] ...