To set a global privilege, use *.* for priv_level. Globally, these privileges apply to all databases, tables, or functions, You canĪlso grant all database, table, and function privileges globally. The following table lists the privileges that can be granted globally. Using the WITH GRANT OPTION clause is equivalent to listing GRANT OPTION The GRANT OPTION privilege will be granted for the entire table. If you use WITH GRANT OPTION when specifying column privileges, The GRANT OPTION privilege cannot be set for individual columns. They cannot grant privileges at a higher privilege level than Users with the GRANT OPTION privilege can To other users at the given privilege level. Use the WITH GRANT OPTION clause to give users the ability to grant privileges You can use ALL instead of ALL PRIVILEGES. Using ALL PRIVILEGES does not grant the special GRANT OPTION privilege. Privileges on a table does not grant any privileges on the database or globally. Privileges only affects the given privilege level. The ALL PRIVILEGES privilege grants all available privileges. YouĬan use USAGE with the GRANT statement to change options like GRANT OPTIONĪnd MAX_USER_CONNECTIONS without changing any account privileges. Statement will show a global USAGE privilege for a newly-created user. The USAGE privilege grants no real privileges. Procedure privileges priv_type are granted using PROCEDURE db_name.routine_nameįor priv_level, or using just PROCEDURE routine_name to specify a procedure.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |