USer ID Priviliges

• Sanjay Mishra

  Valued Member

  Points: 53

  More actions

  August 3, 2004 at 11:13 am

  #85142

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737751

  More actions

  August 3, 2004 at 11:42 am

  #517502

  Pls don't cross post, we check all the forums. Answered in another thread.

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=129930