Function GRANT Object Permissions (Transact-SQL) Login GRANT Server Principal Permissions (Transact-SQL) Message Type GRANT Service Broker Permissions (Transact-SQL) Object GRANT Object Permissions (Transact-SQL) Queue GRANT Object Permissions (Transact-SQL) Remote Service Binding GRANT Service Broker Perm...
DatabaseBACKUP DATABASE,BACKUP LOG,CREATE DATABASE,CREATE DEFAULT,CREATE FUNCTION,CREATE PROCEDURE,CREATE RULE,CREATE TABLE, andCREATE VIEW Scalar functionEXECUTEandREFERENCES Table-valued functionDELETE,INSERT,REFERENCES,SELECT, andUPDATE Stored procedureEXECUTE ...
grant execute on procedure testdb.pr_add to ' dba ' @ ' localhost ' grant execute on function testdb.fn_add to ' dba ' @ ' localhost ' 六、查看 MySQL 用户权限 查看当前用户(自己)权限: show grants; 查看其他 MySQL 用户权限: show grants for dba @localhost ; 七、撤销已经赋予给 MySQL ...
CREATE FULLTEXT CATALOGALTER ANY FULLTEXT CATALOGCONTROL SERVER CREATE FUNCTIONALTERCONTROL SERVER CREATE MESSAGE TYPEALTER ANY MESSAGE TYPECONTROL SERVER CREATE PROCEDUREALTERCONTROL SERVER CREATE QUEUEALTERCONTROL SERVER CREATE REMOTE SERVICE BINDINGALTER ANY REMOTE SERVICE BINDINGCONTROL SERVER ...
Function GRANT Object Permissions (Transact-SQL) Login GRANT Server Principal Permissions (Transact-SQL) Message Type GRANT Service Broker Permissions (Transact-SQL) Object GRANT Object Permissions (Transact-SQL) Queue GRANT Object Permissions (Transact-SQL) Remote Service Binding GRANT Service Broker Perm...
授予 ALL 等同于授予下列权限:BACKUP DATABASE、BACKUP LOG、CREATE DATABASE、CREATE DEFAULT、CREATE FUNCTION、CREATE PROCEDURE、CREATE RULE、CREATE TABLE 和 CREATE VIEW。 PRIVILEGES 包含此参数是为了符合 ISO 标准。 请不要更改 ALL 的行为。 WITH GRANT OPTION 指示该主体还可以向其他主体授予所指定的权限。
If the securable is a table-valued function, ALL means DELETE, INSERT, REFERENCES, SELECT, and UPDATE. If the securable is a stored procedure, ALL means EXECUTE. If the securable is a table, ALL means DELETE, INSERT, REFERENCES, SELECT, and UPDATE. ...
Base de datos BACKUP DATABASE, BACKUP LOG, CREATE DATABASE, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLEy CREATE VIEW Función escalar EXECUTE y REFERENCES Función con valores de tabla DELETE, INSERT, REFERENCES, SELECT y UPDATE Procedimiento almacenado EXECUTE Tabla...
将函数func_add_sql的EXECUTE权限授权给用户joe。 1 2 3 4 5 6 CREATE FUNCTION func_add_sql(integer, integer) RETURNS integer AS 'select $1 + $2;' LANGUAGE SQL IMMUTABLE RETURNS NULL ON NULL INPUT; GRANT EXECUTE ON FUNCTION func_add_sql(integer, integer) TO joe; 将序列serial的UPDATE...
CREATE FULLTEXT CATALOGALTER ANY FULLTEXT CATALOGCONTROL SERVER CREATE FUNCTIONALTERCONTROL SERVER CREATE MESSAGE TYPEALTER ANY MESSAGE TYPECONTROL SERVER CREATE PROCEDUREALTERCONTROL SERVER CREATE QUEUEALTERCONTROL SERVER CREATE REMOTE SERVICE BINDINGALTER ANY REMOTE SERVICE BINDINGCONTROL SERVER ...