This is my presentation about ibm bpm problem determination after taking a course from ibm training center.
If you have any suggestion, feel free to put a comment to contribute more about this topic
Month: July 2015
ibm db2 grant select privilege to all tables in a schema of database to one user
linux command to create a linux user (db2 authorize base on linux os user)
|
1 2 |
useradd user_name passwd user_name |
|
1 2 |
db2 connect to datbase_namedb2 -tnx "select distinct 'GRANT select ON TABLE '||'\"'||rtrim(tabschema)||'\".\"'||rtrim(tabname)||'\" TO USER user_name;' from syscat.tables where tabschema = 'schema_name' " >> grants.sql db2 -tvf grants.sql |
note: remember to chmod grants.sql to 775 or 777