-
Titolo
How to resolve missing data in databases drilldowns for Amazon RDS for SQL Server Connection? -
Descrizione
As Amazon RDS for SQL Server Connection, Amazon doesn’t provide sysadmin role to any database user, user can’t give sysadmin role to any database user to provide maximum database privileges to that user. Due to lack of access to this database role, in Amazon RDS for SQL Server connection any database user can’t fetch other databases** details and tables, indexes information if the other databases are not created by that specific database user.
This happens because any user created database implicitly gives ‘db_owner’ role for that database to the creator of that database only, other database users can’t access those database unless explicitly access is given to those database users or the other database user has ‘sysadmin’ role.
As for Amazon RDS for SQL Server connection, user can’t have the ‘sysadmin’ role, we need to explicitly give ‘db_owner’ role for any user created database to the database users who are not the creator of those databases.
Accesso richiesto
Per visualizzare gli articoli della Knowledge Base di livello avanzato, è necessario aver effettuato l'accesso e disporre di un contratto di manutenzione in essere.