如何将用户与数据库的多个方案关联? [英] How to associate a user to multiple scheme of a database?

问题描述

我有一个具有多个架构的数据库，我想创建一个可以登录数据库不同方案的用户.

I have a Database with several schema and i want to create an user who can log In different scheme of my database.

thx.

推荐答案

您可以使用

You can use the proxy feature to enable a user to connect as another user/schema:

proxy_clause允许您控制企业用户[..]在数据库用户被更改时进行连接的能力.

The proxy_clause lets you control the ability of an enterprise user [..] to connect as the database user being altered.

给出模式A和B以及用户USR，您可以:

Given schemas A and B and user USR, you could:

ALTER USER A GRANT CONNECT THROUGH USR;
ALTER USER B GRANT CONNECT THROUGH USR;

这将允许USR使用其标识符作为A或B连接，如

This would allow USR to connect as A or B using his identifiers, as shown in this askTom thread:

CONNECT USR[A]/PASSUSR

这将使USR能够像他A一样进行连接.

This will make USR able to connect as if he was A.

这篇关于如何将用户与数据库的多个方案关联?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！