Summary: Revokes EXECUTE privileges on provided schema and procedure name to a single user-host combination.Įxecute privileges must be revoked one procedure at a time using * for all available procedures will result in an error. Summary: Revokes EXECUTE privileges on provided schema and function name to a single user-host combination.Įxecute privileges must be revoked one procedure at a time using * for all available procedures will result in an error. Summary: Procedure revokes specified privileges of the provided user. Summary: Provides a list of all your account users that is, all users with the same prefix (first part of the username). Summary: Provides a list of all available API procedures. You can also get to this description by running: CALL api.help('me') įor a list of all procedures ran: CALL api.listProcedures() api.listProcedures This documentation includes three sections: description, procedure parameters, and examples. Summary: Displays the help associated with each of the API's procedures. Summary: Grants EXECUTE privileges on the provided schema and procedure name to a single user-host combination. Summary: Grants EXECUTE privileges on the provided schema and function name to a single user-host combination. If you want to know the privileges that a particular user has, run:ĬALL api.showGrants('prefix_suffix', '%') Use the procedure api.createUser to add additional users. You can obtain a list of your current users by calling api.listUsers(). You can only grant privileges to already existing users. Summary: First revokes all current user privileges and then replaces them with the one(s) provided Summary: Drops user with provided username and host api.grant It must contain at least two special characters.It must contain at least two lower and two upper case characters.It must be at least nine characters in length.When trying to do so you will receive an error ( ERROR 1396 (HY000): Operation CREATE USER failed for password must satisfy the following requirements: Do not use this procedure to grant additional read access to an already existing user. If you want to know the privileges that a particular user has, run: SHOW GRANTS for always creates a new user. When granting privileges, MySQL does not check for the existence of the schema and will therefore grant privileges to non-existing schemas. Make sure that you supply the correct name for the schema's suffix. Summary: Creates schema user and grants it SELECT, INSERT, UPDATE, and DELETE privileges on the specified schemas. The procedure only takes into consideration those schemas that contain at least one table "empty schemas" (that is, schemas with no tables), are ignored. Summary: Provides the size (in MBs) of all your account schemas. To access a detailed description of each procedure, including a list of parameters and examples, run a statement within MySQL using the following format: CALL api.help('procedureName') api.checkDbSize This information is a quick reference to explain the API stored procedures available in MySQL for Sitehost and RDC.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |