3同行回答
something similar to this:
db2look -d -z -x
see an example:
[db2inst1@q1 ~]$ db2 grant select on table employee to user db2inst2
DB20000I The SQL command completed successfully.
[db2inst1@q1 ~]$ db2look -d sample -z db2inst1 -x
-- No userid was specified, db2look tries to use Environment variable USER
-- USER is: DB2INST1
-- Specified SCHEMA is: DB2INST1
-- Schema name is ignored for the Federated Section
-- This CLP file was created using DB2LOOK Version "10.5"
-- Timestamp: Mon 20 Jan 2014 02:01:04 PM GMT
-- Database Name: SAMPLE
-- Database Manager Version: DB2/LINUXX8664 Version 10.5.0
-- Database Codepage: 1208
-- Database Collating Sequence is: IDENTITY
CONNECT TO SAMPLE;
--------------------------------------------
-- Authorization Statements on Tables/Views
--------------------------------------------
GRANT SELECT ON TABLE "DB2INST1"."EMPLOYEE" TO USER "DB2INST2" ;
COMMIT WORK;
CONNECT RESET;
TERMINATE;收起
db2look -d
see an example:
[db2inst1@q1 ~]$ db2 grant select on table employee to user db2inst2
DB20000I The SQL command completed successfully.
[db2inst1@q1 ~]$ db2look -d sample -z db2inst1 -x
-- No userid was specified, db2look tries to use Environment variable USER
-- USER is: DB2INST1
-- Specified SCHEMA is: DB2INST1
-- Schema name is ignored for the Federated Section
-- This CLP file was created using DB2LOOK Version "10.5"
-- Timestamp: Mon 20 Jan 2014 02:01:04 PM GMT
-- Database Name: SAMPLE
-- Database Manager Version: DB2/LINUXX8664 Version 10.5.0
-- Database Codepage: 1208
-- Database Collating Sequence is: IDENTITY
CONNECT TO SAMPLE;
--------------------------------------------
-- Authorization Statements on Tables/Views
--------------------------------------------
GRANT SELECT ON TABLE "DB2INST1"."EMPLOYEE" TO USER "DB2INST2" ;
COMMIT WORK;
CONNECT RESET;
TERMINATE;收起
浏览736