Re: create synonyms

Try creating a view;

grant all on bob.mytable to public
create dbo.public_view view as select a, b from bob.mytable

Regards

--
Andrew Prosser

ogerardin_at_yahoo.com wrote in message <6m3jg6$qjf$1_at_nnrp1.dejanews.com>...


>Hello there,

>

>In trying to translate DB creation scripts from Oracle to SQL server 6.5,

 I've


>come to the conclusion that there is no equivalent to the "create synonym"

>statement of Oracle... This is a real problem for me, since the tables are

>to be created as some user, and accessed as another user. With Oracle,

 using


>synonyms allowed me to refer to a table simply as "tablename" and not as

>"tableowner.tablename".

>

>Does anyone know what is the way to create synonyms with SQL server; or to

>access another user's tables without having to prefix them with his name?