可以的,具体语法要看你的后台DBMS所支持的SQL语言了,
这里的赋权限是给DBMS的用户赋权限。
下面是DB2中授权的类别,有六种,都举了例子,可以直接写到SQL中运行。
具体详细的内容请参考DB2联机文档。
给服务器授权 GRANT (Server Privileges):
GRANT PASSTHRU ON SERVER SERVALL TO USER RSMITH,USER JJONES;
给表或视图授权 GRANT (Table, View, or Nickname Privileges):
GRANT INSERT, SELECT ON TABLE T1 TO GROUP D024, USER D024;
给程序包授权 GRANT (Package Privileges):
GRANT EXECUTE ON PACKAGE CORPDATA.PKGA TO USER EMPLOYEE;
给模式授权 GRANT (Schema Privileges):
GRANT CREATEIN, DROPIN ON SCHEMA CORPDATA TO BIGGUY;
给数据库授权 GRANT (Database Authorities):
GRANT CONNECT ON DATABASE TO USER WINKEN, USER BLINKEN, USER NOD;
给索引授权 GRANT (Index Privileges):
GRANT CONTROL ON INDEX DEPTIDX TO USER USER4;