duplicate instance of Auth Domain in SMC

[japsas100]

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?

[Patrick]

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. 

[japsas100]

@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?

[SimonDawson]

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

[japsas100]

@SimonDawson @Patrick 

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

[SimonDawson]

@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.

[Patrick]

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.

[SASKiwi]

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