Home  • Database • Microsoft SQL Server

Create and Change User, SQL Server

/* Create a user for a specified database */
create LOGIN isl_amira WITH PASSWORD='*****', CHECK_POLICY = OFF;
GO

USE master;
GO
DENY VIEW ANY DATABASE TO isl_amira;
GO

USE master;
GO
ALTER AUTHORIZATION ON DATABASE::IBO_GAMCA_AMIRA TO amira;
GO
/* Change Password */
ALTER LOGIN isl_amira WITH PASSWORD = '******';
GO
Other Method: https://www.cocosenor.com/articles/office/how-to-change-sql-sa-password-from-a-command-prompt.html

Comments 0


Share

Copyright © 2024. Powered by Intellect Software Ltd