run as user

Question

run as user

bhogue

Grasshopper

Points: 20
More actions
June 8, 2007 at 2:06 pm

#93099

I need some help with SQL Server 2000.
BACKGROUND - We just installed someone else's SQL Server DB on our box. It has a job that runs once a month. It calls one SP. The job won't run. The developer says that we need to change the RUN AS USER to their administration ID. The RUN AS USER "option" is greyed out. The developer and his DBA have never seen this greyed out.
QUESTION - how do I "ungrey" this option?

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

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

SQLBill SSC Guru Points: 51440 More actions · Answer 1

Who is the database owned by? (In Enterprise Manager, right click on the database, select properties). What permissions do you have on the database?

-SQLBill

bhogue Grasshopper Points: 20 More actions · Answer 2

Thanks for the fast reply.

The owner is company name\Administrator.

We restored their DB. I believe their owner is serc_admin since all of the queries need FROM serc_admin.tablename. We want to RUN AS USER serc_admin ... if we get the option "ungreyed."

The owner of the SP is serc_admin. The Administrator (from above) does not have EXEC permission on this SP. Are you suggesting that I need to check on that box?

george sibbald SSC Guru Points: 104210 More actions · Answer 3

could it be greyed out because all users in the database are orphaned following the restore from a different server.? Chck using exec sp_change_users_login 'report'.

If so you need to add useers as a login first, synch them using sp_change_users_login 'update_one' and then I would chanfe db_owner to 'serc_admin' (sp_changedbowner 'serc_admin' whilst in database)

---------------------------------------------------------------------