IBM DB2 Grant Privileges to Db User




$ db2 "GRANT ACCESSCTRL, CONNECT, CREATETAB, CREATE_EXTERNAL_ROUTINE, CREATE_NOT_FENCED, CREATE_SECURE_OBJECT, DATAACCESS, DBADM, IMPLICIT_SCHEMA, QUIESCE_CONNECT, SECADM, SQLADM, WLMADM, LOAD ON DATABASE TO USER appcore"


Source :

https://www.ibm.com/docs/en/db2/11.1?topic=authorities-database-administration-authority-dbadm

https://www.ibm.com/docs/en/db2/11.1?topic=statements-grant-database-authorities

https://www.ibm.com/docs/en/db2/11.1?topic=ownership-database-authorities

Comments