Page tree
Skip to end of metadata
Go to start of metadata

you can check the right of user on DB2 server, by executing this query against your database :

SELECT * FROM SYSCAT.DBAUTH WHERE GRANTEETYPE = 'U'

you need to have at least the same right (admin right) as users listed in the table bellow to better run any DB2 online analysis:

 

GRANTOR

GRANTEE

GRANTEETYPE

BINDADDAUTH

CONNECTAUTH

CREATETABAUTH

DBADMAUTH

EXTERNALROUTINEAUTH

IMPLSCHEMAAUTH

LOADAUTH

NOFENCEAUTH

QUIESCECONNECTAUTH

LIBRARYADMAUTH

SECURITYADMAUTH

ADMINDB2

ODSWB

U

Y

Y

Y

N

Y

N

N

Y

N

N

N

ADMINDB2

ADMINISTRATOR

U

Y

Y

Y

N

Y

N

N

Y

N

N

N

  • No labels