check , if it is Y or N



select CREATETABAUTH,DBADM from sysibm.sysdbauth where GRANTEE = 'TEST1'


if Y , that user has create table authorization


revoke it from him by using


revoke CREATETABAUTH,DBADM on database from user TEST1;


that will revoke his DB privileges.


Let me know , if any issues.


Thank You


Lekharaju Ennam

-----Original Message-----
From: Richard Flores
[mailto:db2udbdba-ezmlmshield-x59904931.[Email address protected]
Sent: Thursday, October 28, 2004 3:18 PM
To: LazyDBA Discussion
Subject: create table privileges


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?



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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