Unanswered: Restricting create tab authority of a user
We do not want to give create table access to a user. The user creates a table and drops it. According to him its not possible to create a db2 temporary table. To get around the problem, I was thinking about granting create table access to the user only on a specific tablespace.
I do not favour giving implicit schema authority to a user ..
Originally posted by cchattoraj
You can do that by granting use of a specific tablespace only (like userspace) to the user. The user will however need createtab and implicit schema at the database level to do this.
Visit the new-look IDUG Website , register to gain access to the excellent content.