about DBMS:grant /revoke

除了select delete update alter drop index //All

grant 、revoke 可能会在不经意中用到，特别是在数据安全越来越重要的阶段。

grant 用来对某用户特定的表赋予某种权限。

• GRANT SELECT ON table1 TO user1;

• GRANT SELECT, INSERT, UPDATE, DELETE ON table1 TO user1;

• GRANT ALL ON table1 TO user1;

• GRANT ALL ON table1 TO public;

赋予function/procedure   EXECUTE

• GRANT EXECUTE ON project TO user1;

• GRANT EXECUTE ON PROJECT TO public;

收回某种权限

• revoke ALL on table1 from usre1;
• revoke delete on table1 from public;
• revoke execute on project from public;