Create Table permissions needed in SYSTEM database in SQL SERVER RDS

Question

We have an application, which needs to create table in system database in SQL SERVER RDS.

We are getting , below error while trying to create a table.
The following SQL Server error or errors occurred:

262,"42000",[Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE TABLE permission denied in database

SQL:

CREATE TABLE [dbo].

Answer

Hello!

Thank you for taking time to write a question on re:Post.
  
I understand that you have a requirement from your application to create a Table in the system database for RDS SQL Server. I would like to inform you that unfortunately you are not allowed to make changes on any of the system databases. 
  
"To deliver a managed service experience, Amazon RDS does not provide shell access to DB instances, **[and it restricts access to certain system procedures and tables that require advanced privileges](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureSupport.Limits).**"
  
If you have no other option to create the table in the system database, you can consider making use of [Amazon RDS Custom](https://aws.amazon.com/rds/custom/):
  
"Amazon RDS Custom allows businesses with applications that need customization of the underlying operating system and databases that support them while getting all the time-saving, durability, and scalability benefits of a managed database service. "
  
Please also feel free to reach out to us directly with the detail of the requirements so that we can see if we can help you further.

Create Table permissions needed in SYSTEM database in SQL SERVER RDS

Relevant content