also be aware of the privileges granted to "PUBLIC"
rahul
>>> "Lekharaju Ennam "
<db2udbdba-ezmlmshield-x19150363.[Email address protected] 29/10/2004
6:12:35 am >>>
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
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
***** IMPORTANT INFORMATION *****
This document should be read only by those persons to whom it is
addressed and its content is not intended for use by any other
persons. If you have received this message in error, please notify
us immediately. Please also destroy and delete the message from
your computer. Any unauthorised form of reproduction of this message
is strictly prohibited.
St George Bank Limited AFSL 240997 or its subsidiaries ASSIRT Pty Ltd
AFSL 240979, Advance Asset Management Limited AFSL 240902, PACT
Accountants Investment Group Pty Limited AFSL 240693, St George Life
Limited AFSL 240900, ASGARD Capital Management Limited AFSL 240695
and Securitor Financial Group Limited AFSL 240687 is not liable for
the proper and complete transmission of the information contained in
this communication, nor for any delay in its receipt.
**********************************************************************
DB2 & UDB email list listserv db2-l LazyDBA home page