I have successfully created and configured a Pluggable Database.
I am able to connect to the database and perform DDL Procedures, I am also able to access the database and it's tables in Visual Studio and perform queries on the tables as well.
Now, I would like to access the Pluggable Database in SQL Server; from the Management Studio using Link Server. Is this possible?
I attempted to do this but cannot connect the Link Server, it failed. Importantly, I am not sure what permission is needed by the Pluggable Database Admin account to access link server. I am able to connect with the System account credentials but after connecting with the system account, I do not see the Pluggable Database under the link server objects listed.
I am not certain if this is caused by the lack of certain privileges on the PDB account. I do not want to provide indiscriminate privileges to the Pluggable Database Admin account. This is the account created when you create a PDB.
If this helps. Below is a screenshot of the error I get when attempting to create Link Server with PDB Admin account.
My questions are:
- Does Pluggable Database support Link Server?
- If yes to the above, How do I create a link server for a specific PDB.
Thank you.