如何创建同义词和权限？

我好像在为同义词创建密码时遇到一些问题。

I seem to be having some problems creating a pass word for a synonym.

你是什么意思？您不能为w同义词定义密码。

What do you mean? You can''t define password for w synonym.

设置密码是什么意思？我担心您无法为SYNONYM设置任何密码。


您可以创建一个只能由您创建它的USER使用的PRIVATE SYNONYM或创建PUBLIC SYNONYM如果你想在所有用户之间使用同义词。


检查这里了解更多细节。

What do you mean by setting a password? I am afraid you cannot set any password for a SYNONYM.

You can either create a PRIVATE SYNONYM that can be used only by the USER using which you have created it or create a PUBLIC SYNONYM if you want the synonym to be used across all users.

Check here for more detail.

好的我觉得我明白了吗？所以你不能创造这个同义词的密码。


现在我已经决定放弃DEV1同义词。现在我正在尝试使用代码重新创建它作为公共同义词

Ok i think i understand?So you can''t create a password for that synonym.

Now I''ve decided to drop the DEV1 synonym.And now i''m trying to recreate it as a public synonym using the code