Hi ,

I need to revoke ddladmin(CREATE/ALTER/DROP) permission from a user on a specific schema on the database.

I tried DENY ALTER but user is still able to CREATE Objects but not able to ALTER or DROP.

Need to stop Create also .

Any Suggestions/ ideas/help /links are welcome.

Thanks in advance :)

Regards,

Hitesh Lall