DB2 Grant User Into Schema

on

Follow these steps.

$ db2 "CONNECT TO DBPUBLIC"

$ db2 "SET SCHEMA APPCORE"

$ db2 "GRANT ALL ON SCHEMA APPCORE TO usrdebian"

 

Check result, execute this query.

SELECT distinct p.AUTHID, p.PRIVILEGE, p.OBJECTNAME, p.OBJECTSCHEMA, p.OBJECTTYPE
FROM SYSIBMADM.PRIVILEGES P, SYSIBMADM.AUTHORIZATIONIDS A,
TABLE (SYSPROC.AUTH_LIST_GROUPS_FOR_AUTHID('HLOESER')) as U
WHERE p.privilege='CREATEIN' and a.authidtype='G' and a.authid=p.authid
AND (u.group=a.authid or a.authid='PUBLIC')
UNION
SELECT distinct p.AUTHID, p.PRIVILEGE, p.OBJECTNAME, p.OBJECTSCHEMA, p.OBJECTTYPE
FROM SYSIBMADM.PRIVILEGES P
WHERE
p.authidtype = 'U' AND
p.authid NOT IN ('DB2INST1', 'PUBLIC', 'YOURUSER')
ORDER BY AUTHID ASC, PRIVILEGE ASC;

 

Source :

https://www.google.com/search?q=stackoverflow+db2+add+authid+schema+to+another+user

https://stackoverflow.com/questions/51040390/how-to-list-the-specific-user-acces-type-for-the-database-in-db2

Comments

Post a Comment