Post reply

Creating an object with a different owner

  • July 22, 2002 at 1:47 am

    #57938

    Hi,

    If I am logged in as SA, can I use SET USER to run a script which creates an object with a different owner?

    Thanks

  • July 22, 2002 at 5:52 am

    #433157

    Not sure, but try. If not then you can reference the name of the user in the object creation to put under them.

    Ex.

    CREATE TABLE username.tblname

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • July 22, 2002 at 6:26 am

    #433159

    after you create the object, you can use sp_changeobjectowner to change the owner of the object.

    Derek


    Derek

  • July 23, 2002 at 3:58 am

    #433215

    Yes, create table user_name.table_name does a job

    zoran

Viewing 4 posts - 1 through 3 (of 3 total)

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