2 Risposte
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
1
As documented bulkadmin and dbcreator server roles are not supported in Amazon RDS for SQL Server.
To give permissions to a new user to create databases you can execute
GRANT CREATE ANY DATABASE TO [my_user];
The user will become database owner for any new database they are creating and will be able to drop the database.
To allow the user to delete backup history on drop, you need to grant permissions on sp_delete_database_backuphistory
.
USE [msdb]
CREATE USER [my_user] FOR LOGIN [my_user] WITH DEFAULT_SCHEMA=[dbo]
GO
GRANT EXECUTE ON [dbo].[sp_delete_database_backuphistory] TO [my_user]
Hope this helps.
con risposta un anno fa
0
Thanks for your help !
Is it possible to have an alternative and create an RDS database with default language = French instead of having English as the default language?
con risposta un anno fa
Contenuto pertinente
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 6 mesi fa
- AWS UFFICIALEAggiornata 2 anni fa