topic Re: duplicate instance of Auth Domain in SMC in Administration and Deployment

duplicate instance of Auth Domain in SMC

japsas100 — Tue, 09 Jun 2020 00:15:38 GMT

Dear All,

We need to create the duplicate authenticate domain in SAS management console so that the same user can connect to the oracle with two different SAS OID accounts.

How we can create duplicate authenticate domains in the SAS management console?

Re: duplicate instance of Auth Domain in SMC

Patrick — Tue, 09 Jun 2020 01:03:59 GMT

You can't.

But you can create two different authentication domains each with one of the users assigned. And you then use one or the other auth domain in the libname definition.

Re: duplicate instance of Auth Domain in SMC

japsas100 — Tue, 09 Jun 2020 01:08:49 GMT

@Patrick

Thanks for your reply. How I can add duplicate auth domain in smc? I added another domain just right click on 'user manager'. Do I need to add the server as well? Can you please share the steps?

Re: duplicate instance of Auth Domain in SMC

SimonDawson — Tue, 09 Jun 2020 01:31:19 GMT

How to do what @Patrick is describing uses syntax documented in this section of the documentation.

Re: duplicate instance of Auth Domain in SMC

japsas100 — Tue, 09 Jun 2020 01:36:32 GMT

@SimonDawson @Patrick

I am asking if we create the duplicate domain in smc where we need to make changes?

Re: duplicate instance of Auth Domain in SMC

SimonDawson — Tue, 09 Jun 2020 01:54:46 GMT

@japsas100 You can't have two authentication domains with the same name. You will have two different authentication domains. e.g. authdom01, and authdom02 with different credential. Then inside your various programs you'd use two different libname statements.

libname myora oracle path=mydb authdomain=authdom01; vs libname myora oracle path=mydb authdomain=authdom02;

You'd end up connecting to the same Oracle instance with different credentials depending on which authdomain you specified.

Re: duplicate instance of Auth Domain in SMC

SASKiwi — Tue, 09 Jun 2020 02:15:21 GMT

@japsas100 - You right click on SMC Server Manager and select Authentication Domains. In the Authentication Domains panel click New to create a new one.

Re: duplicate instance of Auth Domain in SMC

Patrick — Tue, 09 Jun 2020 05:18:50 GMT

Manage Authentication Domains
Add an Authentication Domain
1. On the Plug-ins tab, select User Manager (or Server Manager).
2. Right-click and select Authentication Domains.
Note: This menu item is available only if you have user administration capabilities.
3. In the Authentication Domains Management dialog box, click New.
4. In the New Authentication Domain dialog box, enter a name.

Once you've got the authentication domain you add it to the connection of your database server. Eventually create a new connection.

Then go to the user manager, select the group which should provide access to this new authentication domain, add in the account tab a new entry and fill in the 3 fields for authentication domain, user and password.

Now you're all set and you can define a libname which uses the new authdomain. Any user which is a member of the metadata group where you've defined the account will be able to use the libname.