July 22, 2002 at 1:47 am
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
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
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
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