REVOKE CREATE TABLE is not removing the permission

Question

I gave the following permission to user1 so user1 can create tables on database1:

GRANT CREATE TABLE TO user1 WITH GRANT OPTION

I verified that user1 can create table.

Then I ran the following command to revoke the above permission:

REVOKE CREATE TABLE FROM user1 CASCADE

But user can still login to database1 and create table. Question: Why user1 can still create a table on the same database1. How can we revoke the CREATE TABLE from user1?

Remark: As stated here REVOKE would have failed if we had not used the CASCADE. But I'm using CASCADE in the above sql

Answer 1

Sometime user have permission from other database roles or server role. In this case you shoud deny instead of Revoke.

Also if the user is db_owner or sysadmin then you can not revoke or deny any permission from that user.