在 DB2 V10 以后的版本,对所有的数据库对象的授权开始严格管控起来,通常的只有创建对象的用户才能拥有较多的操作权限,而别的认证用户往往需要主动显示赋权,否则将报出以下错误信息:
SQL0551N "JANE" does not have the privilege to perform operation "SELECT" on object "AS.KBPSZ".
SQL0552N "JANE" does not have the privilege to perform operation "INSERT" on object "AS.KBPSZ".
SQL0553N "JANE" does not have the privilege to perform operation "UPDATE" on object "AS.KBPSZ".
SQL0554N "JANE" does not have the privilege to perform operation "ALTER" on object "AS.KBPSZ".
SQL0555N "JANE" does not have the privilege to perform operation "INDEX" on object "AS.KBPSZ".
SQL0556N "JANE" does not have the privilege to perform operation "DELETE" on object "AS.KBPSZ".
SQL0557N "JANE" does not have the privilege to perform operation "REFERENCES" on object "AS.KBPSZ"