I have a DB2 schema, "TEST1'.



I have a DB2 user, "TEST1', which has privileges to connect to the database,
no 'create tables' privilege, and no explicit schema privileges (such as
CREATEIN) on schema, 'TEST1'.



When the user logs into the database with the 'TEST1' ID using command
editor, he is able to create a table in the TEST1 schema.



This is not what I expected. Is there a way I can prevent TEST1 ID from
creating or altering tables in the TEST1 schema?

Is there something I'm missing?


DB2 & UDB email list listserv db2-l LazyDBA home page