Hi .

I need that a user don't have permissions to Create objects in Database.
The user (XPTO) don't have grants to CREATETAB and CREATEIN and USE TABLESPACE .
but when ,"in test ", I make a connect with this user (XPTO) and make a create table ( ... ) , the table will be created .
what can I do to don't allow that user (XPTO) can create an object in a Database .


Thanks.

Revoke the privileges from PUBLIC. By default PUBLIC has the privileges to connect to database, create table etc. thus every new user inherits them, so revoking from PUBLIC will solve your problem.

dollar

Thanks dollar.