Connections are automatically connecting to Secondary AccessID
Hello EveryOne,
We have two Accessid connected to same database.
We are getting issue while user trying to run a job, the Job is connected to secondary accessID,instead of Primary i.e SYSADM .
We have configured all userprofile with SYSADM1 symbolic ID tagged to SYSADM .
This is New setup having (two AccessIDs for one PSFT DB), we havn't followed any document to setup .
We are implementing AIAS architecture U@DB model for the client, as part of this Intranet user will have access to SYSADM schema and internet users will be access to Secondary access ID, we will grant access to tables only used for Internet users with limited access to PS tools and Application tables..