DBO SChema Creating Tables

  •  

    Hi All,

    I created a SQL login, Its just belongs to the public role, it also belongs to a role called DEV.

    DEV role can create tables, but how can I make users belonging to HEX create tables in the DBO schema. If I create a table now, it doesnt belong to the dbo schema.

    I dont want to grant them dbo role.

    Is this possible, I hope to hear from you soon.

    Thanks


    Kindest Regards,

    John Burchel (Trainee Developer)

  • When users create objects, they must qualify the object name with 'dbo' i.e.

    create table dbo.mytable

    Greg

     

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply