如何创建同义词和权限？ [英] How to create synonym and privileges?

问题描述

您好！


我正在尝试使用同义词创建两个不同的数据库用户。私有和公共。我已设法使用语法<创建同义词br />

Hello!

I''m trying to create two different users for database using a synonym.Private and public.I''ve managed to create a synonym using the syntax

展开 | 选择 | Wrap | 行号

推荐答案

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

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

展开 | 选择 | Wrap | 行号

这篇关于如何创建同义词和权限？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！