I have a userid who is doing DML like Select/insert/Delete. Now he need to have create table priviliges and so I want that
--> He can only been able to create Table and not able to drop the table.
--> When he create table, it will be created as dbo.tablename. I can tell hime to create them explictly using dbo.tablename but if he didn't mention then I don't want that it should be created in his own schema.
Thanks and I really if any expert can reply at his/her earliest convenience