我的操作过程: 1) x2:create db test restrict 2) x2: create table x; insert into x 3) x2: grant connect on database to user x1; grant select on x to user x1; 4) x1: connect to test; select * from x2.x 报错: SQL5193N The current session user does not have usage privilege on any enabled workloads. SQLSTATE=42524
查询x1的权限: sysibmadm.privilieges中: AUTHID AUTHIDTYPE PRIVILEGE GRANTABLE OBJECTNAME OBJECTSCHEMA OBJECTTYPE -------- ---------- --------- --------- ---------- ------------ ---------- x1 U SELECT N X x2 TABLE
sysproc.auth_list_authotities_for_authid('x1','U')): AUTHORITY D_USER D_GROUP D_PUBLIC ROLE_USER ROLE_GROUP ROLE_PUBLIC D_ROLE ------------------------- ------ ------- -------- --------- ---------- ----------- ------ SYSADM * N * * * * * DBADM N N N N N N * CREATETAB N N N N N N * BINDADD N N N N N N * CONNECT N N N N N N * CREATE_NOT_FENCED_ROUTINE N N N N N N * SYSCTRL * N * * * * * SYSMAINT * N * * * * * IMPLICIT_SCHEMA N N N N N N * LOAD N N N N N N * CREATE_EXTERNAL_ROUTINE N N N N N N * QUIESCE_CONNECT N N N N N N * SECADM N N N N N N * SYSMON * N * * * * * SQLADM N N N N N N * WLMADM N N N N N N * EXPLAIN N N N N N N * DATAACCESS N N N N N N * ACCESSCTRL N N N N N N * CREATE_SECURE_OBJECT N N N N N N *