How could I do this?

[drkestrel]

I know I could do the following but forgotten what keywords I need to use to do it.

Basically, i have a SQL Server 2000 table called store created by an SQL user called "publications". What do I need to set up for the windows user MachineName\IUSR_MachineName to run

SELECT * from store

as opposed to

SELECT * from

publications

.store

"?

 

[JohnDTampaBay]

Sounds like you need to change the object owner to dbo, which is the default if no owner is specified for an object. Check out sp_changeobjectowner in BOL.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.