MYSQL 'GRANT' statement allows you to grant access privileges to database account. To achieve same ,syntax is as follow: Syntax:- GRANT privileges [Column_List] ON [Object_Type] Privilege_level To account [IDENTIFIED BY 'password'] [ REQUIRE encryption ] WITH with_option ; Detailed explanation: Privileges:- It indicates that you have assign privileges to account. column_List : - (1) Its optional. (2) Column(s) to which privileges apply. Privileges_level :- Level at which privileges apply. You can use global privileges,database privileges,table specific privileges, column privileges etc. Account :- Which account is being granted privileges. Password: - Specifies password.It replace old password. Required:- Clause specify whether the account has to connect to database server over secure connec...
Comments
Post a Comment