- Need to create a new login and new user with the lowest possible priveledges.
- New login can be created in the 'master' database only. As of now, there is no way to change the database to 'master' from Azure portal.
- Use 'SQL Server Management Studio' using the admin user created at the time of creating a database.
- user master;
- CREATE LOGIN appusr WITH password='xxxxxxx';
- use yourdb;
- CREATE USER appusr FOR LOGIN appusr;
- EXEC sp_addrolemember N'db_datareader', N'appusr';
- EXEC sp_addrolemember N'db_datawriter', N'appusr';
- GRANT EXECUTE TO [appusr];
Search This Blog
How to fix 'dbo' user should not be used for normal service operation vulnerability in SQL Azure Database.
Labels:
Azure,
Vulnerabilitiy
Vipul: A Technology Enthusiast Pursuing Smart Application Development
Driven by a passion for technology and innovation, Vipul embarks on a journey to develop smart and efficient application solutions. His expertise lies in exploring the convergence of Cloud, Data Analysis, and AI integration, paving the way for groundbreaking applications.
With a keen interest in smart application development, Vipul delves into the realm of cloud computing, data analysis, and artificial intelligence, seeking to harness their power to create transformative solutions. His primary focus revolves around high-performance distributed scalable server solutions, addressing the growing demand for robust and scalable systems.
Vipul's passion extends beyond his technical prowess, as he actively engages in the technology community, sharing his knowledge and fostering collaboration. He believes in the transformative potential of technology and is committed to empowering others to explore its possibilities.
-
Need to create a new login and new user with the lowest possible priveledges. New login can be created in the 'master' database only...
-
What is Terraform? Terrafrom is a tool for infrastructure provisioning. Terraform automate and manage your infrastructure, your platform, an...
-
What is a compilation in Angular? An Angular application consists mainly of components and their HTML templates. Because the components and ...