Revoke Privileges

[rbod]

I have a user who creates a table [there is no restrict on drop defined during table creation]. By default this user gets all the privileges on that table.
I revoked all the privileges from this user except for select,insert,update and delete privileges. [public does not have any privileges] This user can still alter the table,drop the table etc.
Is there a way to restrict this user, who is the definer of this table, from dropping/altering the table.

thanks for your time and help.

 

[MarcLodge]

Rbod,

Presumably, you've tried REVOKE ALTER ON TABLENAME FROM USERID with no success. How about revoking all prvileges, and then adding back in the select etc. Does that make any difference?

Marc

 

[rbod]

thanks Marc. I had tried that already [even revoked select, so basically no privileges except connect], but still it can alter/drop tables it created.
I understand that since it is the creator it has all these privileges, but looking for a way to revoke those privileges.

thanks for your time.